Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06512: at "SYS.DBMS_STATS

846280May 11 2011 — edited May 11 2011
Getting Error when I am trying to take new statistics for a schema...

SQL> exec DBMS_STATS.gather_schema_stats('OPS$LOADER');

BEGIN DBMS_STATS.gather_schema_stats('OPS$LOADER'); END;

*
ERROR at line 1:
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 13591
ORA-06512: at "SYS.DBMS_STATS", line 13937
ORA-06512: at "SYS.DBMS_STATS", line 14015
ORA-06512: at "SYS.DBMS_STATS", line 13974
ORA-06512: at line 1



SQL> exec DBMS_UTILITY.analyze_schema('OPS$LOADER','COMPUTE');


BEGIN DBMS_UTILITY.analyze_schema('OPS$LOADER','COMPUTE'); END;

*
ERROR at line 1:
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_DDL", line 256
ORA-06512: at "SYS.DBMS_UTILITY", line 391
ORA-06512: at line 1




SQL> execute dbms_stats.gather_schema_stats(ownname => 'OPS$LOADER',estimate_percent => dbms_stats.auto_sample_size, method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE, DEGREE => 2);

BEGIN dbms_stats.gather_schema_stats(ownname => 'OPS$LOADER',estimate_percent => dbms_stats.auto_sample_size, method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE, DEGREE => 2); END;


*
ERROR at line 1:
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 13591
ORA-06512: at "SYS.DBMS_STATS", line 13937
ORA-06512: at "SYS.DBMS_STATS", line 14015
ORA-06512: at "SYS.DBMS_STATS", line 13974
ORA-06512: at line 1


Friends pls help me to solve this?

Rgds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on May 11 2011
6 comments
2,856 views