Re: MultiMaster Replication

Good reply.
1. When the site comes up, the pending transactions are pushed. 2. I would prefer to have a BEFORE INSERT trigger at the destination site
to populate :new.pkey value from the next value of the sequence. That way there would be no changes to the Oracle Replication environment.

HTH
GovindanK
Oracle Certified Professional

On Sun, 21 Aug 2005 07:19:13 -0700 (PDT), "Fuad Arshad" <fuadar_at_yahoo.com> said:
>
> I've been reading up on multimaster replication and had a few questions.
>
> 1. After the multimaster replication setup there needs to be a master
> definition site. if the communication breaks between 2 sites will we
> have to change the master definition site.
>
> 2. the tables the i'm trying to replicate have sequences that i need to
> transform to sequences on the other side.
>
> oracle seems to say its possbile but i cant find an example.
>
> If anyone on the list has had experience with multimaster. if they could
> drop me an email and we could chat a little bit offline that would be
> really great.
>
>

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