Re: global sequence as unique identifier across multiple databases

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: "Dunbar, Norman" <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>
  • Date: Wed, 1 Aug 2007 10:03:21 -0700

On 8/1/07, Dunbar, Norman <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>
> Aargh !
>
> >> 9...9/1000/60/60/24/365.25/1000 = 316880878140290 millennia.
> >> 9...9/1000000/60/60/24/365.25/1000 = 316880878140.29 millennia.
>
> And of course, the above is consuming only one sequence value at a time
> - ie, one site. With two sites, divide by two and so on.
>
>
Number of sites doesn't matter.
Each site starts with one of the values in 1..1000
Each site increments the sequence by 1000.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: