ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600

ORA-00600

原创 Linux操作系统 作者:shuchangjun 时间:2011-03-24 13:26:55 0 删除 编辑

ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], []
 ORA-08102: index key not found, obj# 9029, file 3, block 35919 (2) 

.查看对象
 
SQL> select owner,object_name,object_type from dba_objects where object_id=9029;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS
WRH$_ENQUEUE_STAT_PK
INDEX

 
2.比较结果
SELECT /*+ FULL(t1) */  *
FROM WRH$_ENQUEUE_STAT t1
MINUS
SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ *
FROM WRH$_ENQUEUE_STAT t2;


 
select /*+ FULL(t1) */ SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT  t1
MINUS
select /*+ INDEX(t2 WRH$_ENQUEUE_STAT_PK) */  SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT  t2;


3.查看表的数据

SQL> SELECT /*+ FULL(t1) */  count(*)
  2  FROM WRH$_ENQUEUE_STAT t1 ;

  COUNT(*)
----------
    124732

SQL> SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ count(*)
  2  FROM WRH$_ENQUEUE_STAT t2;

  COUNT(*)
----------
    124591

SQL>


 
4.清索引
 ALTER TABLE WRH$_ENQUEUE_STAT  DROP CONSTRAINT WRH$_ENQUEUE_STAT_PK;

5.创建约束
 ALTER TABLE WRH$_ENQUEUE_STAT ADD (
  CONSTRAINT WRH$_ENQUEUE_STAT_PK
 PRIMARY KEY
 (DBID, SNAP_ID, INSTANCE_NUMBER, EQ_TYPE, REQ_REASON)
    USING INDEX
    TABLESPACE SYSAUX);
 

第二天,同样报错,后来看看WHR开头的表,发现查询结果都不一致,后来把所有约束清掉,然后重建,解决了,ora-00600问题

 

本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/shuchangjun/archive/2011/03/21/6264978.aspx

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11763200/viewspace-690360/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORA-20000
请登录后发表评论 登录
全部评论

注册时间:2008-03-28

  • 博文量
    15
  • 访问量
    24610