Replication and update conflict resolution

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 30 Dec 1999 07:17:44 GMT
Message-ID: <386c0033.18380780@172.16.7.5>

Hello,

I have 2 databases(8.0.5),and SIDs are DB1,DB2 Now I need to replicate data from DB1 to DB2 (replicate SCOTT's schema), I configure multi-master replication with Replication Manager.

My question is,I want to use site priority for the update conflict resolution. For example.....If DB1 and DB2 update DEPT at the same time, DB1 > update dept set dname = 'MIS DB1' where deptno = 10; DB1 > commit;

DB2 > update dept set dname = 'MIS DB2' where deptno = 10; DB2 > commit;

When DB1 and DB2 replicating transaction to each other, I hope DB1 site is high priority and DB2 is low. So after propagating the transactions above, The dname of DEPT in DB1 and DB2 should be 'MIS DB1' where deptno = 10;

But I don't know how to configure the resolution. Can anybody give me some sample code?

Best Regards.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Thu Dec 30 1999 - 01:17:44 CST