Friday, March 6, 2015

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).


No comments:

Post a Comment