My Oracle Support Banner

DataPump Import (IMPDP) Fails With Errors ORA-39776 ORA-00600 [klaevcnulcolnum] (Doc ID 794507.1)

Last updated on AUGUST 04, 2018

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.
***Checked for relevance on 30-NOV-2012***

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.