What are best references on issues re synchronizing several Oracle databases that have same data

Home -> Community -> Usenet -> c.d.o.server -> What are best references on issues re synchronizing several Oracle databases that have same data

From: tony <ramdan_at_mailexcite.com>
Date: 1 Oct 1998 14:47:00 -0500
Message-ID: <0_QQ1.1565$Tc.350826@newscene.newscene.com>

We are going to have several systems, all oracle, that will have all be d/ling customer and metering info from Oracle gateway on mainframe. Several columns will be same but some will require differnet info from mainframe. We have two issues:

1- what is best way to get info off oracle gateway (to DB2 on MVS). Redo logs, import/export files, sql?

2. what is best way to make sure all get same info (without building a massive data warehouse) and that info is synchonize and data integrity is maintained accross all Oracles Received on Thu Oct 01 1998 - 14:47:00 CDT