IMPDP Failing with ORA-00001: unique constraint in oracle

oracle

When I try to import a dump which contains data from several tables, the import fails with ORA-00001: unique constraint as there are several entries which are matching in the destination database, but there are several other values in the same table which are not getting imported due to unique constraint error. I need those values.

Can some one help me out in solving this . I cannot use truncate / replace.

I have used this command:

impdp system/oracle@LIQ727DO directory=DATA_PUMP_DIR dumpfile=EXPDP_ACM_TABLES_LIQ72.DMP
  logfile=IMPDP_ACM_TABLES_LIQ72.log remap_schema=LIQ728:LIQ727 TABLE_EXISTS_ACTION=append

Best Answer

impdp ... data_options=skip_constraint_errors

Above works only for non-deferred constraints though.

link