IMPDP Fails With ORA-39776 And ORA-00600

출처 :  메타링크



Applies to:
====================
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.



Symptoms
====================
During Datapump import (IMPDP) into an existing table  using the TABLE_EXISTS_ACTION=TRUNCATE command line parameter the following errors are raised:

. . imported "AMS"."CNTRBUDGET" 195.2 KB 2327 rows
ORA-31693: Table data object "AMS"."CNTRBUDGETUNIT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39776: fatal Direct Path API error loading table "AMS"."CNTRBUDGETUNIT"
ORA-00600: internal error code, arguments: [klaevcnulcolnum], [], [], [], [], [], [], []
ORA-31693: Table data object "AMS"."CUSTCREDITCARD" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
Dropping the table prior to import allows IMPDP to succeed.



Changes
====================
The table contained in the export dump contains NULL values for a column which is defined as NOT NULL in the existing table into which the data is imported.



Cause
====================
The cause of this problem has been identified and verified in an unpublished Bug 6996535. It is caused by Datapump direct path import not handling NOT NULL constraint violations properly. Instead of raising the ORA-1400 error, the constraint violation was not handled properly and resulted in the ORA-600 [klaevcnulcolnum] error instead.



Solution
====================
The issue has been fixed in the 11.2 release.

Workarounds are to:

- recreate the table to mimic the table definition of the source database so to allow IMPDP for the loading of the NULL values, or:
- drop the table and allow IMPDP to create the table as part of the import operation



References
====================