Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Advanced replication 1

Advanced replication 1

From: Issa Semaan <isemaan_at_sinfor.fr>
Date: Tue, 29 Jun 1999 08:22:54 +0100
Message-ID: <7l9s65$t2l$1@news4.isdnet.net>


QUESTION 1 : In an environment of replication Muti-Master with 3 masters sites (A, B and C) , all master sites containing in their main group the same table X filled with the same data :
- A Local application on site A removes a data D of table X, then validates
(transaction 1).
- Another local application on the site B then tries to update the same data
d of table X (transaction 2).
In this case, Oracle detects a conflict of replication and tries to solve it.

1. How does Oracle try to resolve this conflict?
2. If Oracle does not manage to resolve this conflict, how does it reacts?
2.1. Are the transactions rolled back ? If yes, which one and on which site
??
2.2. How are the applications informed of the failure of the transactions? Received on Tue Jun 29 1999 - 02:22:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US