Errors ORA-24795 ORA-6512 ORA-600 [Kupdls_rddata_01] [ORA-01400 Cannot Insert Null} On DataPump Import (IMPDP) (Doc ID 1112238.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
**Checked for relevance on DD-Mon-YYYY***


Symptoms

When you import into a not null column, you get the errors:

Import: Release 10.2.0.4.0 - 64bit Production on Monday, 19 October, 2009 11:09:14
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=export dumpfile=te
st_exp_imp.dmp logfile=test_exp_imp.log table_exists_action=truncate full=n status=0
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39153: Table "MASTER"."YT_EXP_IMP_TEST" exists and has been truncated. Data will
be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
ORA-39153: Table "MASTER"."YT_EXP_IMP_TEST2" exists and has been truncated. Data willbe loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.LOAD_DATA while calling KUPD$
DATA.START_JOB [TABLE_DATA:"MASTER"."YT_EXP_IMP_TEST"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-00600: internal error code, arguments: [kupdls_rdData_01], [ORA-01400: cannot insert NULL into (COL2)], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
7000000244da110 15032 package body SYS.KUPW$WORKER
7000000244da110 6372 package body SYS.KUPW$WORKER
7000000244da110 3908 package body SYS.KUPW$WORKER
7000000244da110 6986 package body SYS.KUPW$WORKER
7000000244da110 1314 package body SYS.KUPW$WORKER
7000000298fcd88 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at 11:09:25
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1352
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 7073
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 13353
ORA-24795: Illegal COMMIT attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 15039
ORA-06512: at "SYS.KUPW$WORKER", line 6372
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.LOAD_DATA while calling KUPD$
DATA.START_JOB [TABLE_DATA:"MASTER"."YT_EXP_IMP_TEST"]
ORA-06512: at "SYS.KUPW$WORKER", line 3908
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-00600: internal error code, arguments: [kupdls_rdData_01], [ORA-01400: cannot insert NULL into (COL2)], [], [], [], [], [], []
ORA-06512: at line 2


If you want to import lot of tables and you get this error, then the import terminates.

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