Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 command 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,

share|improve this question
    
Could be bug 13840704 - "ORA-12012 / ORA-6502 from Segment Advisor (DBMS_SPACE/DBMS_ADVISOR) for LOB segments [ID 13840704.8]" - please search on Oracle support if you're getting errors on standard functions. –  Mat Feb 23 '13 at 8:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.