Can you provide example about plsql and sql handler conflict of DBVisit replicate for me?
1. About PLSQL conflict handler ,Now I try to following you document "https://dbvisit.atlassian.net/wiki/display/ugdr/PLSQL+Conflict+Handler" but not work for me.
Can you provide step for produce easy example for me?
2. About 2-way replicate
2.1 I try to test something. I create 1 table on 2 site and use 2-way replicate ( 2 APPLY Processes)
"create table x (id number,name vachar(20),timestamp date);
"ALTER TABLE x ADD CONSTRAINT PK1 PRIMARY KEY (ID);"
2.2 when I insert data with timestamp into table in 2 site (source and target) together.
"insert into x values (1,'x',SYSDATE);
*** On 2 site together(same time) ***
2.3 I got error on both 2 apply process, ERROR Primary key
if I resolve as IGNORE on 2 site Thus now data on 2 site will different.
Can you help me, Please provide solution for this example?
Please sign in to leave a comment.