RE: shared database sequence.

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Feb 2007 13:46:49 -0500

 
What about using the Oracle provided SYS_GUID function to provide unique
ID's across instances?

-- Mark D Powell --
Phone (313) 592-5148


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling
Sent: Monday, February 26, 2007 11:55 AM
To: sjaffarhussain@xxxxxxxxx
Cc: oracle-l
Subject: Re: shared database sequence.

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 
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l


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


Other related posts: