Database Utilities (MOSC)

MOSC Banner

IMPDP with REMAP_DATA and REMAP_SCHEMA fails with ORA-00001: unique constraint violated

edited Jul 17, 2018 5:03AM in Database Utilities (MOSC) 2 commentsAnswered

Using REMAP_SCHEMA and REMAP_DATA parameters in a impdp parfile seems to be incompatible.

I have wrote a PLSQL package containing a function that remaps id when importing data.

In the source database, data below to user A

In the target dataabse, data must be remap in user B.

That works fine if importing in the same schema, but when using both REMAP_SCHEMA and REMAP_DATA parameters , impdp fails with ORA-00001.

Id column has a PK constraint.

In this case, remap function seems not to be used.

RDBMS release is 11.2.0.4 on AIX.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center