We have replication configuration between two 8i database. Today we are getting the below error at the time of replication running.
ORA-12012: error on auto execute of job 3
ORA-12008: error in snapshot refresh path
ORA-00001: unique constraint (DBO.PROD_CONT_UN_DIV_PN_PCTY) violated
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_IREFRESH", line 577
ORA-06512: at "SYS.DBMS_REFRESH", line 211
ORA-06512: at line 1
My question is what method replication process is taking at the time of replicate the data ?
Adding to that, we have refresh the data in the source table recently and from that time onward we are getting this error.