Re: global sequence as unique identifier across...

On 8/1/07, Dunbar, Norman <norman.dunbar@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

Re: global sequence as unique identifier across multiple databases

Jared Still

2007-08-01