My Oracle Support Banner

ORA-31693 And ORA-31603 During IMPDP Of Partitioned Table (Doc ID 764439.1)

Last updated on APRIL 03, 2020

Applies to:

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

Symptoms

When importing a partitioned table and using REMAP_SCHEMA and REMAP_TABLESPACE, the following errors are raised:

ORA-31693: Table data object "<SCHEMA>"."<TABLE NAME>":"PARTITION NAME>"
failed to load/unload and is being skipped due to error:
ORA-31603: object "<TABLE NAME>" of type TABLE not found in schema "<SCHEMA NAME>"
ORA-31693: Table data object "<SCHEMA>"."<TABLE NAME>":"<PARTITION NAME>"
failed to load/unload and is being skipped due to error:
ORA-31603: object "<TABLE NAME>" of type TABLE not found in schema "<SCHEMA>"



The import parameter file looks like:

CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=expdp.dmp
INCLUDE=TABLE_DATA
LOGFILE=expdp.log
TABLES=(<OWNER>.<TABLE>)



The export parameter file looks like:

CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=expdp.dmp
INCLUDE=TABLE_DATA
LOGFILE=impdp.log
REMAP_SCHEMA=(<SCHEMA 2>:<SCHEMA 1)
REMAP_TABLESPACE=(<TBS 1>:<TBS 2>,<TBS 3>:<TBS 4>)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.