推荐订阅源

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

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

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

解决方法：

ALTER TABLE 表名 MOVE tablespace 表空间名 ;

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.