Replication between two Oracles

From: Steven Crimmins <crimmins_at_nospam.us.easyphone.com>
Date: 27 Sep 1999 08:01:37 PDT
Message-ID: <37ef85cb.9533528@news.concentric.net>

Hi,
I have the following scenario and would appreciate any suggestions.
(I would also ask that you email responses to me.)

We have an Oracle 8 running on NT Server and a separate Oracle 8 running on Solaris for x86. There will be a T1 link between the two Oracle's with TCP/IP.

There is a series of tables on the Oracle 8 Solaris that need to be replicated (or perhaps the data will be shared in a different fashion) to the Oracle NT.

The rate of transactions is low. One or two tables may have less than 10 transactions per minute. The remaining two or three tables usually only have perhaps 100 updates that occurs in the evening.
(There are only about 5 tables total to "share".)

What are my best options to keep the data in synch? I do not need instantaneous updating to occur, however I would like Oracle to handle the Oracle to Oracle communications if possible (hence I would not change the underlying applications).

If any suggestions are priced products (which is acceptable) please let me know the relative price of the components and where they need to be installed.

Thanks
Steve Received on Mon Sep 27 1999 - 10:01:37 CDT