Bi-directional data synchronization with basic replication

From: Romi <romi.mht_at_gmail.com>
Date: 2 Mar 2005 04:54:01 -0800
Message-ID: <dd5edc55.0503020454.25e3a1b6@posting.google.com>

Hi,

I would have one central database and two sites databases, all oracle 10g standard edition.
Site 1 and 2 will have their own set of data while central database will have data from both sites as well as its own data. Each set of data is identified by site_id.

Data can be added/modified/deleted in site database as well as central database.

Thus there is a need for bidirectional data synchronization with conflict resolution through timestamp.

I am planning to create tables in central database and updatable materialized views in site databases. data synchronization will happen every 3 hours.

Is this supported in Oracle 10g standard edition i.e. with basic replication ? Info available w.r.t. basic replication is very confusing :-(

Thanks,
Romi Received on Wed Mar 02 2005 - 06:54:01 CST