ORA-08102
: index key not found, obj# 304067, dba 33580767 (2)
oerr ora 8102
08102, 00000, "index key not found, obj# %s, dba %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
错误信息的意思似乎是需要重新建立索引。
SQL> SELECT owner, object_name, object_type
2 FROM Dba_Objects
3 WHERE object_id IN (304067);
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------------------------------------------------------------------- ------------------
SHARE001 IDX_SHARE_TMP_IPID INDEX
SQL>alter index share001.IDX_SHARE_TMP_IPID rebuild online；
oerr ora 8102
08102, 00000, "index key not found, obj# %s, dba %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
错误信息的意思似乎是需要重新建立索引。
SQL> SELECT owner, object_name, object_type
2 FROM Dba_Objects
3 WHERE object_id IN (304067);
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------------------------------------------------------------------- ------------------
SHARE001 IDX_SHARE_TMP_IPID INDEX
SQL>alter index share001.IDX_SHARE_TMP_IPID rebuild online；
问题解决！
本文转自东方之子736651CTO博客，原文链接：http://blog.51cto.com/ecloud/1675202 ，如需转载请自行联系原作者
