ORA-00600 [kluinit:new add column in directpath 2] While Running Expdp (Doc ID 1298313.1)

Last updated on MAY 30, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms


* Data Pump Worker process fails with:
ORA-00600: internal error code, arguments: [kluinit:new add column in directpath 2], [], [], [], [], [], [], [], []

* The Data Pump Export log shows:
ORA-31693: Table data object "TUSER"."TAB1" failed to load/unload and is being skipped due to error:
ORA-2354: error in exporting/importing data
ORA-600: internal error code, arguments: [kluinit:new add column in
directpath 2], [], [], [], [], [], [], [], [], [], [], []
Master table "TUSER"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded8

* Checking the generated trace file the following information is found:

========= Dump for incident 30225 (ORA 600 [kluinit:new add column in directpath 2]) ========
*** 2011-01-28 05:23:20.169
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=1k1yrfsgnu5yw) -----
SELECT * FROM RELATIONAL("TUSER"."TAB1")
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
39f8ed4e0 18 package body SYS.KUPD$DATA_INT
39f949410 3340 package body SYS.KUPD$DATA
38ea4a358 14258 package body SYS.KUPW$WORKER
38ea4a358 3254 package body SYS.KUPW$WORKER
38ea4a358 9068 package body SYS.KUPW$WORKER
38ea4a358 1688 package body SYS.KUPW$WORKER
389071878 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1 ksedst kluinit kpodpuls opiodr kpoodr upirtrc kpurcsc  kpudpxuls_ctxUnload kupduls_writePass1 kupduls spefcifa
spefmccallstd  peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool
........
Dump of memory from 0x10b020820 to 0x10b020960
10B020820 6B6C752E 63403534 36320000 00000000 [klu.c@5462......]
10B020830 6B6C752E 63403534 36390000 00000000 [klu.c@5469......]
10B020840 6B6C752E 63403534 39310000 00000000 [klu.c@5491......]
10B020850 6B6C752E 63403535 30390000 00000000 [klu.c@5509......]
10B020860 6B6C7569 6E69743A 6E657720 61646420 [kluinit:new add ]
10B020870 636F6C75 6D6E2069 6E206469 72656374 [column in direct]
10B020880 70617468 20320000 66756C6C 206B6579 [path 2..full key]
10B020890 203A2044 69726563 7420556E 6C6F6164 [ : Direct Unload]
10B0208A0 00000000 00000000 64656C61 79656420 [........delayed ]


Changes


A column with "DEFAULT n NOT NULL" is added while the data pump export is running in direct path mode, e.g:

SQL> alter table TAB1 add (COL7 NUMBER(1,0) DEFAULT 0 NOT NULL)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms