Data Pump Import with REMAP_SCHEMA Does Not Remap Some References Embedded in Column Definitions

(Doc ID 2060135.1)

Last updated on SEPTEMBER 25, 2015

Applies to:

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


When datapump import is performed using the remap_schema parameter, references inside column definitions are not identified and changed.

For example, in the source database:


  Note that the sequence, seq1, is still in dptestcase's schema.


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