4 Replies Latest reply on Jul 15, 2021 6:15 AM by sri sri

    Synchronization task with insert operation

    sri sri Seasoned Veteran

      Hi Experts,


      I started working with Cloud Data Integration and while working with Synchronization task came across below scenario.


      I created a synchronization task to insert data from multiple oracle tables to a oracle target.


      I defined a primary key on target and running synchronization task(truncate target table not enabled) multiple times without changing data in source, but the data is getting appended every time in target. I expected failure in second run as primary key is there on target, but it is not. When trying to insert duplicates into table manually getting below error.

      ERROR: "ORA-01502-"Index '[xxx]' or partition of such index is in an unusual state"


      Can you help me in understand this.