删除数据报ORA-00600: internal error code, arguments: [ktbesc_plugged]

Oracle在删除数据是以下错误：

ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], []

原因是由于进行过表空间的传输操作。

解决方法：

ALTER TABLE 表名 MOVE tablespace 表空间名 ;

 

 

Ora-600 [Ktbesc_plugged] Error On Insert Or Delete (文档 ID 1372941.1)

转到底部

---

In this Document   This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2] Information in this document applies to any platform. SYMPTOMS Receiving the following error on insert or delete against one particular table. ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], [] Call Stack Trace = ktbesc -> kdiescpin -> kdifind -> kdiblTestPrefixUniqueness -> kdiblLockPiece -> kdiblLockRange CHANGES Table is located on a recently plugged in tablespace into an 11.2.0.3 database. CAUSE Bug:12919564 where this problem was introduced in 11.2.0.3.  SOLUTION We successfully used a temporary workaround of moving the problem table to another tablespace.  Once moved, we were able to insert or delete without issue. alter table <table name> move tablespace <tablespace name>; There is an additional workaround of setting "_fastpin_enable"=0 which is discussed in Document 12919564.8.  Long term resolution would be to apply one-off Patch:12919564.