Re: Replication Issues

From: Peter Robson <pgro_at_bgs.ac.uk>
Date: Wed, 16 May 2001 15:44:37 +0100
Message-ID: <3B029255.101CD326@bgs.ac.uk>

Just for the record,we have been running replication against Oracle for more then 10 years, using SQL*Plus scripts initiated from Unix cron. Its all totally transparent.. Latest versions now upgraded to use rowid (like Ora snapshots), but (unlike Ora snappers), we can do master-master updates. Yes, complex, BUT fundamentally you have to understand your busniess model, and make very sure it is consistantly modelled into the database. If a yes to these, then replication is really very logical.

peter
edinburgh
............

Khurram Izhar wrote:

> Hi All,
>
> I am working on an oracle replication project. The replication has to take
> place between Oracle 7.3.4 to any other databaes. I just wanted to confirm
> is there a possibility of replicating from Oracle 7.3.4 to SQL 7.0??
>
> Also if SQL is not possible can we replicate from Oracle 7.3.4 to Oracle
> 8.1.5.0.0?
>
> I have been working on SQL for the past couple of years, oracle is new to
> me.
>
> Waiting for the expert advice.
>
> Thanks
> Khurram
Received on Wed May 16 2001 - 09:44:37 CDT