Getting Fatal Error On DataPump Import (IMPDPD) Of A Dump With Data Compression (Doc ID 1102503.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

You are running a DataPump to import a table which was exported with on another database. The import fails with errors:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "OPS$ORACLE"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "OPS$ORACLE"."SYS_IMPORT_TABLE_01": /******** full=n directory=DATA_PU
MP_DIR dumpfile=DATA_PUMP_DIR:SBT4expdp%u_051110.dmp parfile=imp.par logfile=impdp.log
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Job "OPS$ORACLE"."SYS_IMPORT_TABLE_01" stopped due to fatal error at 13:50:26

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