删除数据出错

删除数据出错:

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

问题解决:
将索引都删除,包括主键
然后删除数据
再建立索引

posted on 2006-03-01 16:27    阅读(345)  评论(0编辑  收藏  举报

导航