ORA-08103: object no longer exists >> WRH$_SQLTEXT
jhowardJan 21 2012 — edited Jan 23 201211.2.0.1.0, Solaris 64 bit
exec dbms_stats.gather_dictionary_stats;
The following error is returned:
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 20508
ORA-06512: at "SYS.DBMS_STATS", line 20957
ORA-06512: at "SYS.DBMS_STATS", line 23353
ORA-06512: at "SYS.DBMS_STATS", line 23396
ORA-06512: at line 1
Through a process of elimination, I found this occurs with the sys.wrh$_sqltext table:
BEGIN
SYS.DBMS_STATS.GATHER_TABLE_STATS (
OwnName => 'SYS'
,TabName => 'WRH$_SQLTEXT'
,Estimate_Percent => SYS.DBMS_STATS.AUTO_SAMPLE_SIZE
,Method_Opt => 'FOR ALL COLUMNS SIZE AUTO '
,Degree => NULL
,Cascade => TRUE
,No_Invalidate => FALSE);
END;
/
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 20337
ORA-06512: at "SYS.DBMS_STATS", line 20360
ORA-06512: at line 2
The table exists and you can select from it. You just can't gather stats on it.
Have you seen this sort of thing before? Any chance it's a bug?