||Oracle Replication Tips by Burleson
Oracle Assigning Blocks of Numbers Via Sequences
value for a sequence equal to 1.0E28, you have a very large pool to
divide between the master sites.
There are two key points to remember. First, set up an automated
check of the sequences to warn you if any site begins to approach
maxvalue. Second, don’t forget the future possibility of adding
additional master sites. If you divide the available number equally
between all master sites, adding one master site cuts the available
number for one site in half to make room for the new site. This
issue alone makes this method of generating unique keys less
Remember to check dbms_reputil.from_remote=FALSE inside the trigger
to insure that the trigger does not fire on a transaction from a
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.