-
Title
Running append command results in error “row rejected due to ORACLE error 1”, “ORACLE error 1 -
Description
When running an append on a table, it fails on target with following errors (as seen in the copy client log):
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (OWNER.TARGET_CONSTRAINT_NAME) violated
-
Cause
The append command takes the rows from the source table and appends them to the target table and runs into ORA-0001 during the process due to unique constraints enabled on target table.
-
Resolution
If unique constraints are enabled on target table, running append can result in the copy process trying to add duplicate rows to the target table and this action fails due to ORA-0001. There is no harm done since the target table should not get duplicate rows when append fails. If wishing to append rows from source table even if it involves creating duplicate rows on the target table, then the unique constraint needs to be disabled first on the target table before the append command is run.