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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nigel Thomas
Sent: 18 July 2007 10:29
To: paulastankus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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.

Other related posts: