Re: Oracle Advanced Replication

[Quoted] [Quoted] On 2 Dec 2002 13:27:37 -0800, harpreetsingh1_at_yahoo.com (harpreet) wrote:

>I want to set up asynchronus replication of transactions in oracle . I
>want to use oracle 9i to be the master or masters . The
>replicated/recieving site runs on oracle 8.0.6 . Is this configuration
>supported by oracle , where 9i master can propagate changes to lower
>versions(8.0.6) ?
>If possible , are there any caveats or pre requisits to do so ? Also
>any tips on the subject .

8.0.6 is not supported, and likely you are going to run into problems by setting up the higher version database as the master defining site.

The main caveat is that when you have master/master replication (so the other site is not a mere 'snapshot site') and you don't set up a conflict resolution mechanism to process deferred transactions, you will sink in a swamp of unresolved problems. One of my customers ran into this problem *more than 3 years ago*, they didn't notice it, and you don't want to know the state of that database right now.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Dec 02 2002 - 23:35:02 CET