impdp: error ORA-29913: error in executing ODCIEXTTABLEOPEN callout with Solution

impdp: error ORA-29913: error in executing ODCIEXTTABLEOPEN callout with Solution

DB hit below error from one of my client during import of a schema:

Starting "SYS"."SYS_IMPORT_FULL_02":  /******** AS SYSDBA dumpfile=exp_DC_OCM_2tbs_29Jan2015_1150_%U.dmp directory=DATAPUMP_DIR3 logfile=imp_exp_DC_OCM_2tbs_29Jan2015_1150.log table_exists_action=replace remap_schema=test:test parallel=24

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

ORA-31693: Table data object "TEST"."CI_TAB2_T" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

. . imported "TEST"."CI_TAB1_K_T"                5.003 MB 1241230 rows

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYS"."SYS_IMPORT_FULL_02" completed with 1 error(s) at 12:04:50

ORA-31693: Table data object "TEST"."CI_TAB2_T" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

This is because of bug 8393456, and same can be confirmed on the Oracle Support website.

The problem seems to be related to cases where you use both PARALLEL (>1) and REMAP_SCHEMA at the same time.
Oracle versions affected are 11.2.0.1, 11.1.0.7 and 10.2.0.4.

Workaround implemented  by setting PARALLEL=1  (even you can user remap_schema) clause

Solution:

Do not user PARALLEL >1 with REMAP_SCHEMA clause in datapump (impdp).