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
