Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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) |
