||Oracle Replication Tips by Burleson
Oracle multi-master replication Conflict Resolution
Establishing conflict resolution is a process of defining rules for
Oracle to apply when a conflict is detected. If the conflict is
resolved, the transaction does not end up in the deferred error column
group that the resolution method applies to.
You can have multiple column groups on a table and define a priority
for each group. A column group can consist of all the columns in
the table or any subset of those columns. Once you have created a
column group, you can assign one or more conflict resolution methods
to it. Oracle has defined a number of standard conflict resolution
methods that will usually meet your needs. The following table
provides a list of the different conflict resolution methods Oracle
Latest Timestamp Value
With the latest timestamp value method,
you define a column that contains a date data type to use in
comparing multiple transactions. When a transaction fails
because the before image has changed, the column timestamps
of the transactions are compared, and if the second
transaction is later than the one changing the before image,
the second transaction is applied and overlays the current
data (which contains the first transaction).
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
Get a Personal Oracle
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.