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?. 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-replication.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

Other related posts: