Delete Datagram ora-00600:internal error code, arguments: [ktbesc_plugged]

Source: Internet
Author: User

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]

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.