ORA-06512: at "SYS.DBMS_STATS
846280May 11 2011 — edited May 11 2011Getting 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