RE: shared database sequence.

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 26 Feb 2007 13:46:49 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9886CF1@usahm208.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Monday, February 26, 2007 11:55 AM To: sjaffarhussain_at_gmail.com
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

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


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

Received on Mon Feb 26 2007 - 12:46:49 CST