Conflict resolution in Symmetric replication

hi,

Could anyone give me more insight on the following:

We have multiple databases spanned across different countries. We want to provide the update anyware feature for these databases, using replication mechanism(either Oracle or inhouse-developed). I am aware of the fact that conflict-resolution rules will be applied to resolve conflicts while propagating changes across the databases. But I am not very clear about how these conflict resolution works. For eg. consider the following scenario:- Suppose we have setup replication to happen every 1 hr across databases D1, D2 and D3. And assume that the conflict resolution rule is that the latest change is accepted. At 6:55 Row r1 in table T1 is deleted by user U1 in database D1. At 7pm Replicator pulls the transaction log from all databases. At 7:01(Before replicator propagate the changes to all databases) Row r1 in table T1 is updated by user U2 in database D2. Now replicator propogate the changes (as of 7pm) to all the databases. So the change done by user U2 will be lost and user U2 will suddenly see the row r1 missing eventhough he has done an update.

Could anyone clarify the above. Or if you think that my doubts are due to lack of knowledge in
conflict-resolution-rules, can you tellme where to find more info on conflict-resoultion-rules in symmetric replication.

Thanks & Regards,

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 30 1998 - 03:36:48 CDT