My Oracle Support Banner

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

Last updated on MAY 17, 2021

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Enterprise 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]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


NOTE: In the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

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

$ expdp system/<PASSWORD> directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>%U.dmp logfile=<LOG_NAME>.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=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>%U.dmp logfile=<LOG_NAME>.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:
<PATH>/expdp_tc01.dmp
<PATH>/expdp_tc02.dmp
<PATH>/expdp_tc03.dmp
<PATH>/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
----------------
<LOG_NAME>.log (6.18 KB) (16-Apr-2015 08:07:17 AM)

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

$ impdp system/<PASSWORD>
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=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>%U.dmp logfile=<LOG_NAME>.log
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

 

Changes

 

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.