Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: replication: sequences, triggers, packages
Oracle SEQUENCE objects cannot be replicated. When we had
a need for the same sequence on two databases, we created the
sequences such that they would never generate the same value.
for example, on one database, the sequence was defined
'start with 1 increment by 2'
and the same sequence on the other database was defined
'start with 2 increment by 2'.
packages will have to be maintained on each database as well.
<zyman_at_my-deja.com> wrote in message news:8qd4uk$p9l$1_at_nnrp1.deja.com...
> HI, How can I replicate sequences, packages ? Or I can on;y setup a
> replication for tables? Thank You.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Sep 21 2000 - 00:00:00 CDT