Re: shared database sequence.

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 26 Feb 2007 09:55:13 -0700
Message-Id: <20070226165453.B5E6B61A4A1@turing.freelists.org>

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 Corporation
www.centrexcc.com

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 26 2007 - 10:55:13 CST