Data Pump Import of Partitioned Table Using REMAP_TABLE Fails With ORA-31693 ORA-29913 ORA-29400 And ORA-39786 Errors (Doc ID 1276141.1)

Last updated on AUGUST 06, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2013***

Symptoms

When using Data Pump to perform a REMAP_TABLE import of a 10.2 partitioned table into a 11.1 pre-created non-partitioned table, it fails with errors:

Example:

impdp system/oracle directory=testcase dumpfile=SCOTTSYSTEMLOGDATA.DMP LOGFILE=SCOTTSYSTEMLOGDATA.LOG tables=scott.systemlog remap_table=scott.systemlog:new_temp

 

ORA-31693: Table data object <schema>.<old_table_name>:<partition_name> failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-39786: Number of columns does not match between export and import

(errors repeat for every partition)

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