Re: global sequence as unique identifier across multiple databases

  • From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
  • To: paulastankus@xxxxxxxxx
  • Date: Wed, 18 Jul 2007 02:28:54 -0700 (PDT)


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: