Post

1 follower Follow
0
Avatar

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);

commit;"

*** 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?

 

Best Regards,

Sontaya H.

sontaya hongmang

Please sign in to leave a comment.