DataPump Import (IMPDP) Fails With Erros ORA-39002 And ORA-39166 (Doc ID 1456865.1)

Last updated on SEPTEMBER 04, 2012

Applies to:

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

Symptoms

DataPump table import reports the following errors:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "OPS$ORACLE1"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
ORA-39166: Object DCT_Q_USER04.D_DOD was not found.
ORA-39166: Object OPS$ORACLE1.DCT_QOD was not found.
ORA-39166: Object OPS$ORACLE1.DCT_Q_UOD was not found.
ORA-39166: Object OPS$ORACLE1.DCT_Q_USEOD was not found.
ORA-39166: Object OPS$ORACLE1.DCT_Q_USER0 was not found.
ORA-39166: Object OPS$ORACLE1.DCT_Q_USER0OD was not found.
ORA-39166: Object OPS$ORACLE1.DCT_Q_USEROD was not found.
Job "OPS$ORACLE1"."SYS_IMPORT_TABLE_01" successfully completed at 14:16:33

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