Index

How to Resolve ORA-08102: index key not found

ORA-08102

Found some ORA-08102 errors during executions of SQL statements like this:

ERROR at line 1:
ORA-08102: index key not found, obj# 98830, file 69, block 120164 (2)

ERROR at line 1:
ORA-08102: index key not found, obj# 98832, file 69, block 120172 (2)

ERROR at line 1:
ORA-08102: index key not found, obj# 98831, file 69, block 120140 (2)

Solution

“index key not found”? I suspected that the above indexes has been corrupted logically. My solution to ORA-08102 is to rebuild those indexes. First of all, we use those object id to compose rebuild statements like this:

SQL> column stmts format a50;
SQL> select 'ALTER ' || object_type || ' ' || owner || '.' || object_name || ' REBUILD;' stmt from dba_objects where object_id in (98829, 98830, 98831) and object_type = 'INDEX';

STMTS
--------------------------------------------------
ALTER INDEX ERPAPP.FINNS5S1 REBUILD;
ALTER INDEX ERPAPP.FINNS6S1 REBUILD;
ALTER INDEX ERPAPP.FINNS7S1 REBUILD;

Then we use these statements to rebuild the indexes.

SQL> ALTER INDEX ERPAPP.FINNS5S1 REBUILD;

Index altered.

SQL> ALTER INDEX ERPAPP.FINNS6S1 REBUILD;

Index altered.

SQL> ALTER INDEX ERPAPP.FINNS7S1 REBUILD;

Index altered.

Problems Solved.

Leave a Reply

Your email address will not be published. Required fields are marked *