Re: Synchronizing 2 databases

From: Van Messner <vmessner_at_bestweb.net>
Date: Tue, 22 Aug 2000 22:12:14 GMT
Message-ID: <2VCo5.2507$kM2.323399@newshog.newsread.com>

If you decide to try replication, read the manuals - there are some potential pitfalls.

"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message news:39A292E9.8308B611_at_edcmail.cr.usgs.gov...
> Peter,
>
> Two different solutions easily come to mind. One, you could use Oracle
> Replication to perform this function. This is an additional (costly)
> option which can replicate a database for you to another server. If all
> you want is to replicate a table, then you can use the much cheaper
> TRIGGERS to perform your replication. Create a trigger on db1 that
> propogates the changes to db2 across a database link.
>
> HTH,
> Brian
>
>
> Peter Elsen wrote:
> >
> > Hi,
> >
> > I've the following problem: we have two Oracle-Databases:
> > one for the internal use in the intranet (7.4.3) and one for the
> > external internet-use behind a firewall (8.1).
> >
> > I need one table to synchronize in both databases. What is the
> > best and easiest way to do this?
> >
> > Thanx for your answering!
> > Peter Elsen
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Tue Aug 22 2000 - 17:12:14 CDT