A replication question/mlml

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

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