'AWS DMS oracle full load failed
I am running an RDS oracle 12 TO RDS Oracle 12. But my task fails with the below error.Could not understand what is the issue.
Last Error Failed to connect to database. Task error notification received from subtask 2, thread 1 [reptask/replicationtask.c:2822] [1020414] Failed executing create PK statement: ALTER TABLE "1234"."MST" ADD CONSTRAINT "SYS_C0011324" PRIMARY KEY ( "SEC", "TARIFF" ); ORA-02264: name already used by an existing constraint ; Handling new table '1234'.'MST' failed; Endpoint is disconnected; Error executing data handler; Stream component failed at subtask 2, component st_2_GP7OZL3BRFLFYLJHGB3UF4TNMYELVSRAJMZIA; Stream component 'st_2_GP7OZL3BRFLFYLJH3UF4TNMYELVSRCXAJMZIA' terminated [reptask/replicationtask.c:2829] [1020414] Stop Reason RECOVERABLE_ERROR Error Level RECOVERABLE
Solution 1:[1]
ORA-02264: name already used by an existing constraint
Cause: The specified constraint name has to be unique.
Action: Specify a unique constraint name for the constraint.
Your constraint name "SYS_C0011324" is system-generated, and appears to overlap with a different system-generated constraint name in the target database. You will need to change the constraint name in one database or the other to avoid the conflict, then try your load again.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | pmdba |
