During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index key not found, obj # XXXXX, file X, block XXXX (2)”. To resolve the error, the relevant index must be moved to a different tablespace, or dropped and recreated.
The error is as follows.
|
1 2 3 4 5 6 |
SQL> ALTER INDEX ADURUOZ.IDX_TESTR REBUILD PARALLEL 16 ONLINE; ALTER INDEX ADURUOZ.IDX_TESTR REBUILD PARALLEL 16 ONLINE * ERROR at line 1: ORA-08102: index key not found, obj# 84300, file 9, block 90039831 (2) |
