delete操作时遭遇ora-600 bug[kntgslm]

数据库版本: 10.2.0.4

delete操作时遭遇ora-600 bug[kntgslm]，下面为处理的操作日志

delete报错

SQL>  DELETE FROM T_CLAIM_PRODUCT WHERE CASE_ID =340147;
 
DELETE FROM T_CLAIM_PRODUCT WHERE CASE_ID =340147
 
ORA-00600: internal error code, arguments: [kntgslm], [0], [], [], [], [], [], []

 

删除表也报错

SQL>  DROP TABLE T_CLAIM_PRODUCT ;

 

DROP TABLE T_CLAIM_PRODUCT

 

ORA-00600: internal error code, arguments: [kntgslm], [0], [], [], [], [], [], []

移表空间还是报错

SQL> ALTER TABLE T_CLAIM_PRODUCT MOVE TABLESPACE users;

 

ALTER TABLE T_CLAIM_PRODUCT MOVE TABLESPACE users

 

ORA-00600: internal error code, arguments: [kntgslm], [0], [], [], [], [], [], []

2.决定重建这个表

(1).建好这个表的物化视图并删除

重命名时报错,分析为存在物化视图日志

SQL> ALTER TABLE T_CLAIM_PRODUCT RENAME TO T_CLAIM_PRODUCT_bak;
 
ALTER TABLE T_CLAIM_PRODUCT RENAME TO T_CLAIM_PRODUCT_bak
 
ORA-26563: renaming this table is not allowed

SQL> create materialized view log on T_CLAIM_PRODUCT;

 

Materialized view log created

 

SQL>  drop materialized view log on T_CLAIM_PRODUCT;

 

Materialized view log dropped

 

(2).把这个表重命名

 

SQL> ALTER TABLE T_CLAIM_PRODUCT RENAME TO T_CLAIM_PRODUCT_bak;

 

Table altered

 

(3).把备份的表改为原表名，T_CLAIM_PRODUCT2是原来备份的一个表

 

SQL> ALTER TABLE T_CLAIM_PRODUCT2 RENAME TO T_CLAIM_PRODUCT;

 

Table altered

 

SQL> DELETE FROM T_CLAIM_PRODUCT WHERE CASE_ID =340147;

 

1 row deleted

 

(4).添加索引和外键

……………..

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

转载于:http://blog.itpub.net/21605631/viewspace-762537/