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).添加索引和外键

……………..