Error ORA-39242 Reported During DataPump Import (Doc ID 1441506.1)

Last updated on SEPTEMBER 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-SEP-2013***

Symptoms

DataPump import (impdp) failed with the following error:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_03" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_03": system/******** dumpfile=dept.dmp table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "SYSTEM"."DEPT" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/PRE_TABLE_ACTION
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39242: Unable to export/import TABLE_DATA:"SYSTEM"."DEPT" due to table attributes.

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