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

Other related posts: