Re: shared database sequence.

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Mon, 26 Feb 2007 18:04:48 +0200

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


2007/2/26, Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>:
Hello List,

Is it possible to share a database sequence between multiple databases? Not
in RAC of course.
We are planning to have two databses exchanging information (replicating)
using third party solution. But, stuck with the issues of sequences.
--
//www.freelists.org/webpage/oracle-l


Other related posts: