Oracle's deletion of data is the following error:
Ora-00600:internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], []
The reason is because of the transfer of the tablespace.
Workaround:
ALTER table name MOVE tablespace table space name;
Ora-600 [ktbesc_plugged] Error on Insert Or Delete (document ID 1372941.1) |
Go to bottom |
|
In this Document
This document was being delivered to your via Oracle support ' s Rapid Visibility (RaV) process and therefore have not been sub Ject 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 = kdibllockpiece, kdibltestprefixuniqueness, Kdifind, Kdiescpin, Ktbesc, Kdibllo Ckrange ChangesTable is located to a recently plugged in tablespace to an 11.2.0.3 database.Cause bug:12919564 Where this problem is introduced in 11.2.0.3. SolutionWe successfully used a temporary workaround of moving the problem table to another tablespace. Once moved, we were able to insert or delete without.
ALTER TABLE <table name> move tablespace <tablespace name>;
There is an additional workaround of setting "_fastpin_enable" =0 which are discussed in Document 12919564.8. Long term resolution would is to apply one-off patch:12919564. |
Delete Datagram ora-00600:internal error code, arguments: [ktbesc_plugged]