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

Last updated on NOVEMBER 28, 2016

In this Document
  Symptoms
  Cause
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Symptoms

When importing a partitioned table and using REMAP_SCHEMA and REMAP_TABLESPACE, the following errors are raised:
ORA-31693: Table data object "SYNC"."SYNCTAB10":"PART_SYNCTAB10_2008"
failed to load/unload and is being skipped due to error:
ORA-31603: object "SYNCTAB10" of type TABLE not found in schema "SYNC"
ORA-31693: Table data object "SYNC"."SYNCTAB10":"PART_SYNCTAB10_MAXVALUE"
failed to load/unload and is being skipped due to error:
ORA-31603: object "SYNCTAB10" of type TABLE not found in schema "SYNC"


The import parameter file looks like:
CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=expdp.dmp
INCLUDE=TABLE_DATA
LOGFILE=expdp.log
TABLES=(OL.SYNCTAB10)


The export parameter file looks like:
CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=expdp.dmp
INCLUDE=TABLE_DATA
LOGFILE=impdp.log
REMAP_SCHEMA=(OL:SYNC)
REMAP_TABLESPACE=(OL:SYNC_DATA,OL_I:SYNC_INDX)

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