RE: global sequence as unique identifier across multiple databases

Oracle FAQs has a list of all the various options, with a bonus "sheesh!" style comment from Noons ;)  

http://orafaq.com/node/1406  

Cheers, APC

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas Sent: 18 July 2007 10:29
To: paulastankus_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: global sequence as unique identifier across multiple databases

Paula  

This has been asked before on this list Is it possible to share a database sequence between multiple databases? <http://www.freelists.org/archives/oracle-l/02-2007/msg01023.html> . Mark Powell suggested use of SYS_GUID as an alternative to sequence ranges, or intercalated sequences as just suggested by Glints. I blogged here
http://preferisco.blogspot.com/2007/02/unique-ids-for-multi-master-repli cation.html that sadly SYS_GUID (in my test at least - OracleXE on a laptop, YMMV) is quite a bit slower than selecting from a sequence.  

Regards Nigel

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

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