Re: Oracle on multiple sites

In this case, the snapshot option is OK, but it must be updatable since both sites can update the data locally. As a result, there's a lot more involved than simple snapshots, particularly in the area of determining how to handle conflicts.

HTH. Pete

Grange Man wrote:

> 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
> >

--

Regards

Pete

Received on Tue Jun 15 1999 - 11:00:59 CDT