Re: global sequence as unique identifier across multiple databases

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: