Re: Oracle on multiple sites

From: Grange Man <nospam_at_yahoo.com>
Date: Tue, 15 Jun 1999 06:15:57 -0500
Message-ID: <376635ED.8DBA4E36@yahoo.com>

You could use Oracle "snapshots" to do this. Snapshots can update the TARGET either at intervals, or by 'manual' activation (with a scheduled script or Oracle "JOB"). The only negative of snapshots is that you must monitor for their success.

Snapshots can be set up to grab only the incremental changes to a large database, so overhead can be small.

Steve-a wrote:

> Hi,
> Looking for some advice on linking 2 /3 sites.
>
> Each site has oracle 8 installed.
> The databases are /should be identical, but any updates must be
> replicated to all sites,
> None of the sites would SQL any other of the sites, since the data would
> be held locally and synced by oracle.
> data flow will be Quite small 20/30 records added/modified per day.
>
> Which setup do I need.
>
> steve
>
Received on Tue Jun 15 1999 - 06:15:57 CDT