Re: A replication question/mlml

From: Michel Lee <ae299_at_FreeNet.Carleton.CA>
Date: 3 Jun 2004 17:59:46 GMT
Message-ID: <c9noui$4dv$1@freenet9.carleton.ca>

Sybrand Bakker (gooiditweg_at_sybrandb.verwijderdit.demon.nl) writes:

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

Hi Sybrand,
I am not sure what you mean about the Updateable Materialized view solution. The large table will be many terabytes. So, whould be materialized view log be too much over head. I only want the data to be inserted from small to large table. No other updates in the large table is allowed. Maybe I dont understand.
cheers
Mike

> 
> 
> --
> Sybrand Bakker, Senior Oracle DBA

--
/-------------------------------------------------------------------/
/             http://miccc.com                                      /
/-------------ae299_at_ncf.ca------------------------------------------/

Received on Thu Jun 03 2004 - 12:59:46 CDT