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.

       

      Thanks,

      Sri.