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

简介: Oracle在删除数据是以下错误: 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.
目录
相关文章
|
11月前
|
数据库
ORA-06553: PLS-801: internal error 的解决办法
搜索了一下,原来是把32位的数据库恢复到64位的数据库了。找到解决方案如下
|
Java 应用服务中间件 Windows
|
SQL 数据库
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了“ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], ...
1324 0
|
网络协议 Oracle 关系型数据库