||Oracle Replication Tips by Burleson
Define the Oracle replication Conflict
Next, we define the conflict resolution method for that column group.
sname => ‘PUBS’,
oname => ‘SALES’,
column_group => ‘SALES_COLGP’,
sequence => 1,
method => ‘LATEST TIMESTAMP’,
parameter_column_name => ‘ORDER_DATE’);
Now, when a conflict occurs on the column group, the first (and
only, for the moment) method of resolution will be the latest date
method (defined via the method parameter). The date within the
column will be used to resolve the conflict.
If we wanted to define a second method, we could use the same
command, but replace the method parameters and change the
sequence to equal two. Oracle will apply the two conflict
resolution methods in the sequence order.
You might have noticed that the above example has limited
usefulness, since the order date is likely to remain the same for
all transactions. It would be more useful to compare the
transaction execution time, rather than the ORDER_DATE.
So let’s alter our replicated object using the procedure
dbms_repace.alter_master_repobject, which we call from the master definition site. With this
procedure, we will
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.