Copy fails with following errors indicating an Oracle error ORA-0001 is encountered on target:
Copy server log portion from source:
Tue Jun 29/19:08:21.886:: 003: Sending end of transmission message
Tue Jun 29/19:08:22.477:: 003: ERROR: Import error on target: rows = 111000 imp error = 19 IMP-00019: row rejected due to ORACLE error 1 at sync/svr/sync_export_thread.cpp:553
Tue Jun 29/19:08:22.484:: 003: WARNING: Thread asked to stop, stopping export at sync/svr/sync_export_thread.cpp:266
Tue Jun 29/19:08:22.484:: 003: WARNING: Sent a server control stop message (line=268) at sync/svr/sync_export_thread.cpp:679
Tue Jun 29/19:08:22.484:: 003: Export process returned status: 0
Tue Jun 29/19:08:22.535:: ERROR: A thread failed on target at sync/svr/sync_svr_messager.cpp:745
Tue Jun 29/19:08:22.539:: Abort remaining threads
Copy client log log portion from target:
Tue Jun 29/19:08:16.643:: 001: Importing table "table_name"
Tue Jun 29/19:08:22.279:: 001: Export is now complete
Tue Jun 29/19:08:22.431:: 001: Error/Warning Detected: IMP-00019: row rejected due to ORACLE error 1
Tue Jun 29/19:08:22.432:: 001: Error/Warning Detected: IMP-00003: ORACLE error 1 encountered
Tue Jun 29/19:08:22.432:: 001: Error/Warning Detected: ORA-00001: unique constraint (owner.name) violated
Tue Jun 29/19:08:22.438:: 001: ERROR: Stopping import thread due to error at sync/clt/sync_import_thread.cpp:141
Tue Jun 29/19:08:22.438:: 001: ERROR: Sending error to server (line=281) at sync/clt/sync_import_thread.cpp:469
Tue Jun 29/19:08:22.438:: 001: WARNING: Import thread asked to stop, terminating imp process at sync/clt/sync_import_thread.cpp:283
Tue Jun 29/19:08:22.439:: 001: External process pid = 22859 sent SIGTERM
Tue Jun 29/19:08:22.462:: 001: Import process returned status: 0
Tue Jun 29/19:08:22.534:: Import thread 1 aborted
T
Import phase of copy fails on target due to ORA-0001
The problem is caused when no unique constraint is enabled on source table or for any reason the source has not enforced uniqueness, whereby duplicate rows exist on source. However, on target, the unique constraint is enabled. So when copy runs, during import phase it errors out with ORA-0001. To get around the issue, one of the following can be done:
1. Disable the constraints on target table and then run copy or compare. This will create a copy of the source table on the target and the target table will then have duplicate rows so one will not be able to enable unique constraint on target.
2. Sanitize (clean) the source data by removing duplicates from source table and then run copy or compare to fix the target table's out of sync.
Â
