In article <364B358F.6D0FCA3D_at_ibm.net>,
sbenyo_at_ibm.net wrote:
From your requirements it appears that you have to opt for snapshot
replication. You can set up snapshot refresh interval to any you want :
once a day or twice a day ...
One draw back of this is that as you will have complex snapshots, you can
not have fast refresh which is a pain because each refresh will take
plenty of time.
Symmetric replication is not an option for you because it only takes data from
a table and propogates it to the table of the same name and structure and
primary key on the remote db. It also compares the old values of row on db1 a
to the current values of the same row on db2 before applying changes(
only if the values match)!
Alternatively you can write your own package using dblinks to keep data
in db3 tables if you have reliable network.
Mvempati
> Hi,
>
> I will first present my problem:
>
> I have two major database sites running oracle 7.3.3 on NT 4.0.
> I need to create a new site combining selected data from the two major
> sites.
> Let's say I have DB1 which has the schema A, and DB2 which has schem A,
> I want to create DB3 which will have a combination of data from schema A
> from DB1 and schema A from
> DB2.
> The data passed to DB3, is a combination of selected data from DB1 and
> some other selected data from
> DB2.
> The selection of data can even be complex joins between some tables in
> schema A of DB1 and DB2.
>
> DB1 and DB2 have to replicate to DB3 selected changes from about 60
> tables each some of them can be
> of about 200,000 rows.
>
> The three sites are connected through 32K wan lines.
> DB3 must be updated at least once a day with changes from sites DB1 and
> DB2.
>
> I will apprecidate any suggestions to solve this problem including
> everything oracle can give (from no
> replication to simple and advaced replication....).
> I is most urgent cause site DB3 must be up working as soon as possible.
>
> 10X
> Shaul.
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Nov 14 1998 - 08:56:26 CST
