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 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms


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.

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