Re: A replication question/mlml

"Michel Lee" <ae299_at_FreeNet.Carleton.CA> wrote in message news:c9m6f1$c7m$1_at_freenet9.carleton.ca...
>
> A replication question/mlml
>
> Hi,
> I have 2 sites far apart(Asia & North America),
> one with a large table , the other with a small table, same structure.
>
> Inserts are done in the small table.
> I would like to copy this data to the large table routinely.
>
> (North America) large table <-----<------ small table (Asia)
>
> How would I do it?
> I thought of a few ways but they dont really fit in.
> 1) MultiMaster Replication (NO)
> 2) Materialized view (NO)
> 3) Updateable Materialized view (NO)
>
> Maybe this is not a replication question?
> This seems like a simple question, but how would I do this?
>
> thanks in advance
> Mike
>
>

4) Use triggers on small table to sync large table via dblinks
5) Routinely copy small table to large table (via db links .. merge)
6) Use Oracle Streams and setup a one way copy from small to large table

Anurag Received on Wed Jun 02 2004 - 23:06:55 CDT