ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numeric o

[ssadoglu]

Hi there,

We have been using Oracle Database - Enterprise Edition 11.2.0.3 running on the IBM AIX on POWER Systems (64-bit). My question / problem is : When trying to run below commmand then I'm getting the following error.

My command :
SQL> exec dbms_space.auto_space_advisor_job_proc;
BEGIN dbms_space.auto_space_advisor_job_proc; END;

Here is my error message :

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-06512: at line 1

Thanks and best regards,

[Tim...]

Hi.

Are you running this as SYS?

Cheers

Tim...

[ssadoglu]

Hi.

Are you running this as SYS?

Cheers

Tim...

Yes,

[Tim...]

Hi.

Then I am at a loss. I think you need to progress this with Oracle support. That is a standard package, so there should be nothing in it that fails... If I run it on my installations it works fine...

Cheers

Tim...