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

Last updated on NOVEMBER 30, 2012

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

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