Re: shared database sequence.

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_at_gmail.com>:
> 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.

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