Re: replication: sequences, triggers, packages

From: <zyman_at_my-deja.com>
Date: Fri, 22 Sep 2000 16:01:16 GMT
Message-ID: <8qfvnt$54f$1@nnrp1.deja.com>

So except tables, views I can replication nothing? Am I correct?
Thank YOu.

In article <QfAy5.928$p67.114476_at_nnrp2.sbc.net>, "spencer" <spencerp_at_swbell.net> wrote:
> 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.
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 22 2000 - 11:01:16 CDT