Re: shared database sequence.

  • From: Maxim Demenko <mdemenko@xxxxxxxxx>
  • To: gints.plivna@xxxxxxxxx
  • Date: Mon, 26 Feb 2007 17:46:33 +0100

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

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


Other related posts: