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 2Similarly can be done for generating unique numbers among more than 2 servers.
Best regards Maxim -- //www.freelists.org/webpage/oracle-l