IMPDP - ORA-31693 ORA-02354 (error In Exporting/importing Data) ORA-39776 ORA-00600 [klaprs_12]

(Doc ID 2002832.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.7.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1. You successfully exported a schema with Export Data Pump, e.g.:

$ expdp system/manager directory=my_dir dumpfile=expdp_tc%U.dmp logfile=expdp_tc.log flashback_time=systimestamp schemas=tc parallel=4

Export: Release 11.2.0.4.0 - Production on Wed Apr 15 13:13:18 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  userid=system/******** directory=my_dir dumpfile=expdp_tc%U.dmp logfile=expdp_tc.log flashback_time=systimestamp schemas=tc parallel=4
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 124.1 GB
...
. . exported "TC"."TAB3"                                 117.1 GB 1405921 rows
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped by user request at Wed Apr 15 18:26:18 2015 elapsed 0 05:21:57
.. exported "TC"."TAB4"                                  145.4 KB     827 rows
. . exported "TC"."TAB5"                                 12.60 KB       0 rows
...
. . exported "TC"."TAB100"                                   0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
 /oracle/export01/expdp_tc01.dmp
 /oracle/export01/expdp_tc02.dmp
 /oracle/export01/expdp_tc03.dmp
 /oracle/export01/expdp_tc04.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Wed Apr 15 18:26:21 2015 elapsed 0 05:12:56

FileName
----------------
exp_creta2.150415.log (6.18 KB) (16-Apr-2015 08:07:17 AM)

2. The import with Import DataPump into a target database fails:

$ impdp system/manager directory=my_dir dumfile=expdp_tc%U.dmp logfile=impdp_tc.log schemas=tc parallel=4

Import: Release 11.2.0.4.0 - Production on Thu Apr 16 08:48:39 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  userid=system/******** directory=my_dir dumfile=expdp_tc%U.dmp logfile=impdp_tc.log schemas=tc parallel=4
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TC"."TAB12"                                96.02 MB  498980 rows
...
. . imported "TC"."TAB22"                                951.3 MB 2051172 rows
ORA-31693: Table data object "TC"."TAB22" 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 "TC"."TAB22"
ORA-00600: internal error code, arguments: [klaprs_12], [17], [3], [1354100], [], [], [], [], [], [], [], []
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
...
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at Thu Apr 16 09:27:57 2015 elapsed 0 00:39:10

 

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