ORA-08102: index key not found, obj# 56687, file 54, block 176049 (2)
delete from B2BADMIN.DELIVERYJOB where DOCID
in(SELECT DOCID from B2BADMIN.BIZDOC where doctimestamp< sysdate -26) ；
Error at line 8
ORA-08102: index key not found, obj# 56687, file 54, block 176049 (2)
在删除表上的历史数据时发现index数据块方面的错误，
mxb2bcoredb01<*wmb2bprd1*/home/oracle>$oerr ora 8102
08102, 00000, "index key not found, obj# %s, file %s, block %s (%s)"
// *Cause: Internal error: possible inconsistency in index
// *Action: Send trace file to your customer support representative, along
// with information on reproducing the error
重建index 后恢复正常， alter index xxxx rebuild online ;
如果需要查看到底时候什么不一致，可以经过analyze table t validate structure cascade; 验证表和索引的完整性。在udump产生一个trace文件。
*** SESSION ID:(570.35812) 2006-01-01 10:49:34.095
row not found in index tsn: 37 rdba: 0xfe037009
.......
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-677164/ ，如需转载，请注明出处，否则将追究法律责任。
