ORA-00600 [kluinit:new add column in directpath 2] While Running Expdp
(Doc ID 1298313.1)
Last updated on JULY 31, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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 DataPump export log shows:
.....
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" 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 indirectpath 2], [], [], [], [], [], [], [], [], [], [], []
Master table "<SCHEMA_NAME>"."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("<SCHEMA_NAME>"."<TABLE_NAME>")
----- 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 ]
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" 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 indirectpath 2], [], [], [], [], [], [], [], [], [], [], []
Master table "<SCHEMA_NAME>"."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("<SCHEMA_NAME>"."<TABLE_NAME>")
----- 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 Datapump export job is running in direct path mode, e.g:
SQL> alter table <TABLE_NAME> add (COL7 NUMBER(1,0) DEFAULT 0 NOT NULL);
SQL> alter table <TABLE_NAME> add (COL7 NUMBER(1,0) DEFAULT 0 NOT NULL);
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |