On 8/1/07, Dunbar, Norman <norman.dunbar_at_environment-agency.gov.uk> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 01 2007 - 12:03:21 CDT
