Re: Replication in N Master-Site

You should consider multi-master-replication if this are Enterprise-Versions!

Helmut

Allen wrote:

> Hi, All:
>
> My customer had 2 DB with the same Schema in different machine (SID=A, B)
> All they want to do is to duplicate some data (where condition was
> defined) from A To B, and they can do any I/O in
> both DB, and partial data will automatic replicate to each other.
>
> As I know, Oracle Snapshot can solve my problem, but B site must to be
> "View", but I can not drop their old schema
> to recreate snapshot view for many reasons.
>
> I had builded the replcation definition and master-site already, and I
> tried to modify the trigger (Table$RR), but I
> can not make sure is there any bug or problem will be occurs, also I do not
> know how Oracle Replication will
> start to execute these Triggers.
>
> So, Can anyone give me some kind of suggestions to build 2 master-site for
> partial replication without
> using master-site -> snapshot-site? and Does Oracle or other 3rd Party
> develops other useful tools ?
>
> I am working on an Oracle 8.0.5.1 database running on SUN Spark
>
> Any information you can provide will be greatly appreciated.
> Thanks a lots
>
> Best Regard,
> Allen
Received on Wed Dec 08 1999 - 02:39:51 CST