Not sure if that's what you mean, but in order to avoid sequence number collisions in databases with replication between them I have used increments <> 1 to create non-overlapping sequences. E.g. in the case of 2 databases use increment by 2 and start the sequences such that one database creates only odd sequence numbers while the other creates only even sequence numbers.
At 02:13 AM 2/26/2007, Syed Jaffar Hussain wrote:
Hello List,Is it possible to share a database sequence between multiple databases? Not in RAC of course. We are planning to have two databses exchanging information (replicating) using third party solution. But, stuck with the issues of sequences.
Regards Wolfgang Breitling Centrex Consulting Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
-- //www.freelists.org/webpage/oracle-l
