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$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博客 ” ,链接:http://blog.itpub.net/35489/viewspace-677164/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-677164/