ORA-08103:Object No Longer Exists

Symptom:

ORA-08103,Index Corruption,ORA-00600

Solution:

1. Check if you have any runtime errors in ST22:

Any ORA-00600 errors or ORA-08103 .

2. From the runtime error try to identify the table having index .

3. Analyze the table and the associated index :

ANALYZE TABLE <OWNER>."<TABLE_NAME>" VALIDATE STRUCTURE ONLINE;

ANALYZE INDEX <OWNER>."<INDEX_NAME>" VALIDATE STRUCTURE ONLINE;

The analyze command will return the ORA-08103 :object no longer exists for the index having issues

4. Save the structure of the index :

SQL> set pagesize 0

SQL> set long 90000

SQL> SELECT DBMS_METADATA.GET_DDL('INDEX','<INDEX_NAME>','<OWNER>') from dual;

5. Drop the index.

SQL> DROP INDEX "OWNER"."INDEX_NAME";

6.  Recreate the index with the saved structure in point 4.

7.  Analyze the index again to find if the issue is solved

Cause of the issue :

We get this error usually when tables are being dropped/truncated while a SQL statement for those tables is still in execution. In the case of an index, it might be caused by an index rebuild. In other words the object has been deleted by another session since the operation began.

Hope this helps!!!

Abraham