DataPump Import (IMPDP) Fails With Errors ORA-31693 ORA-31603 (Doc ID 752351.1)

Last updated on OCTOBER 06, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-May-2013***

Symptoms

Import using DataPump will fail with the following errors when the export dump does not contain information about the metadata:

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "TEST"."TBL" failed to load/unload and is being skipped due to error:
ORA-31603: object "TBL" of type TABLE not found in schema "TEST"
ORA-31693: Table data object "TEST"."DEPT" failed to load/unload and is being skipped due to error:
ORA-31603: object "DEPT" of type TABLE not found in schema "TEST"
ORA-31693: Table data object "TEST"."EMP" failed to load/unload and is being skipped due to error:
ORA-31603: object "EMP" of type TABLE not found in schema "TEST"
ORA-31693: Table data object "TEST"."SALGRADE" failed to load/unload and is being skipped due to error:
ORA-31603: object "SALGRADE" of type TABLE not found in schema "TEST"
. . imported "TEST"."BONUS" 0 KB 0 rows
. . imported "TEST"."TAB1" 0 KB 0 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 4 error(s) at 09:28:41

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