Re: shared database sequence.

Gints Plivna schrieb:
> In case you need not to get overlapping values you can simply define
> one sequence with values starting from 1 to very big number and the
> other from the very big number till very big number * 2
> Or the other with just start with -1 increment by -1
>
> Of the overlapping sequences is not the case, then what is the problem?
>
> Gints Plivna
> http://www.gplivna.eu
>
>

Simply varying start with and increment by should do that equally well - 1st : start with 1 increment by 2
2nd: start with 2 increment by 2
Similarly can be done for generating unique numbers among more than 2 servers.

Best regards

Maxim

--
http://www.freelists.org/webpage/oracle-l