Re: Oracle on multiple sites

Steve

This can be done in a number of ways. Which is correct for you needs more information before you can decide.

1. Replication is designed to handle exactly this sort of situation (see the earlier posts by Jonathan Lewis, Kevin Lewis and myself for more details).
2. Given the small data volumes, it may not be worth the time etc. to set up replication, but maybe you can do something manual. This could be either through the use of database links, or some file based system you write yourself.

HTH. Pete

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 Mon Jun 14 1999 - 11:37:39 CDT