ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: : [rworupo.1], [30], [24]

ORA-00600: : [rworupo.1], [30], [24]

原创 Linux操作系统 作者:rocky_gao 时间:2012-09-01 07:54:38 0 删除 编辑
 

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 06-Oct-2011***

Symptoms

Receiving 'ORA-00600: internal error code, arguments: [rworupo.1], [XXX], [XXX] against one table only.

Call stack:

ksfdmp rworupo kxhrunpack qerhjwalkhashbucket qerhjfetchphase2 qerhjfetch opifch2 kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv opimai_real



Cause

In the case of a specific table, this error is raised when the length of a column value in a row which
we are unpacking from the queue buffer exceeds the length recorded in the corresponding operand descriptor.

ORA-00600: internal error code, arguments: [rworupo.1], [4069], [4000], [], [], [], [], []
indicates the length of the data in the column (4069) exceeds the column length (4000).

Solution

Create table as
Select * from ;

By copying the data into a new table, the data in the column will be re-verified before the insert and it will either fix the data or fail at the bad data row by indicating which row has the bad data.  In turn, the bad data can then be fixed manually.


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11976525/viewspace-742404/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-04-09

  • 博文量
    112
  • 访问量
    299800