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