Re: global sequence as unique identifier across multiple databases


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
 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: