5 Replies Latest reply: Dec 8, 2012 4:43 AM by LazyOraDBA RSS

    OCI Error ORA-00001: unique constraint (abc.PK_xxx) violated (status = 1),

    LazyOraDBA
      Hi Experts,

      I implemented OGG 11.1 and performed initial load as below:
      1. alter extract <extract_name> begin now
      2. alter replicat <replicat_name> begin now
      3. select dbms_flashback.get_system_change_number() from dual;
      4. expdp directory=test_dir flashback_scn=1247929778 dumpfile=abc.dmp logfile=abc.log  schemas=abc
      5. scp abc.dmp.gz oracle@<ip_adress_of_target>:/home/oracle
      6. impdp directory=test_dir dumpfile=abc.dmp logfile=abc_imp.log schemas=abc
      7. disabled triggers and jobs that insert record
      8. disabled FK constraints
      9. start extract <extract_name>
      10.start replicat <replicat_name>, AFTERCSN 1247929778
      Replication is working fine and source & target is in synch but discard file is getting filled with ORA-00001 errors(used exception handler):
      OCI Error ORA-00001: unique constraint (abc.PK_xxx) violated (status = 1), SQL <INSERT INTO "abc"."xxx" (,,,,,) VALUES (:a0,:a1,:a2,:a3,:a4,:a5)>.
      Database error 1 (ORA-00001: unique constraint (abc.PK_xxx) violated).
      SQL error 1 mapping abc.xxx to abc.xxx OCI Error ORA-00001: unique constraint (abc.PK_xxx) violated (status = 1), SQL <INSERT INTO "abc"."xxx" (,,,,,) VALUES (:a0,:a1,:a2,:a3,:a4,:a5)>.
      Error mapping from abc.xxx to abc.xxx.
      Why I am still gettting ORA-00001 errors in discard file ?

      Is there anything wrong in my initial load process ?

      Regards,