删除数据出错
删除数据出错:
ORACLE817
WIN2000
现在是删除其中一个数据出问题
SQL> delete from dequeue where id = '62370152160420656';
delete from dequeue where id = '62370152160420656'
*
ERROR 位于第 1 行:
ORA-08102: 未找到索引关键字,obj# 29293,dba 12596563 (2)
ORA-08102 index key not found, obj# string, dba string (string)
Cause: This is an internal error; possible inconsistency in index.
Action: Send trace file to Oracle Customer Support, along with information on reproducing the error
问题解决:
将索引都删除,包括主键
然后删除数据
再建立索引