Re: A replication question/mlml

On 3 Jun 2004 03:35:16 GMT, ae299_at_FreeNet.Carleton.CA (Michel Lee) wrote:

>
>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

Simple replication would do, no need for multimaster replication. Just set up a snapshot and a snapshot log and a snapshot refresh job. You seem to reject those solutions (looking at the 'NO' label), the alternative would be a remote insert, which is just cumbersome and unstable, compared to replication.

--
Sybrand Bakker, Senior Oracle DBA