||Oracle Replication Tips by Burleson
Oracle Multi-Master replication Examples of Defining Conflict
Let’s look at creating some of the more common resolution methods in our
PUBS schema. First, we will look at an example of the latest timestamp
conflict resolution. Then we will look at using the site priority
conflict resolution method.
Defining Latest Timestamp
Conflict resolution methods are defined using the
procedure. In the following example, we will configure Oracle to
use the latest timestamp method of resolution to settle conflicts
with the pubs.sales
column. In this example we will:
Define a column group for use by the resolution method.
Define the resolution method.
Add additional support as required.
Let’s look at these steps in more detail then.
Define the Column Group
The first step is to define a column group on the master definition
site that uses this resolution method.
In this example, we are defining a column group called
on the sales table in the PUBS schema. This column group will
include every column in the table, since the ‘*’ is being used.
It is not necessary to include all
columns in the column group. Since the
column can act as a primary key, we could have only defined
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.