IMPDP with REMAP_DATA and REMAP_SCHEMA fails with ORA-00001: unique constraint violated
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.