 |
|
Oracle Replication Tips by Burleson |
Defining Oracle replication Site Priority
The site priority conflict resolution method uses a column value to
determine replication conflict priority. Before we start, we need to
stop replication activities for the group (this is known as a quiesce
of the replication group).
We define another column in the pubs.sales table that will contain
an identifier for the site that created the transaction. Next, we
add a trigger to insert a site identifier (usually the database
global name). We then need to define the site priorities, using the
stored procedure dbms_repcat.define_site_priority. Finally, create
the column group and define the conflict resolution method.
First, we need to stop replication as seen here:
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(’REP_GROUP2’);
END;
/
For this example, we added the SALES.SALES_SP
column (varchar2(30)) to use for the site data (an example of adding
a column to a replicated table was shown earlier in this chapter).
Next we need to add the trigger.
create trigger SALES_SP_TG
before insert or update
on PUBS.SALES
SEE CODE DEPOT FOR FULL SCRIPT
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
depot:
http://www.rampant-books.com/book_2003_2_replication.htm
Get a Personal Oracle
Replication Mentor
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.
|
