Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Replication Solution/Software Needed!!!

Re: Replication Solution/Software Needed!!!

From: Robert Mah <rmah_at_ican.net>
Date: 1998/04/28
Message-ID: <6i65g1$pqb$1@news2.tor.accglobal.net>#1/1

I am also working with mixed Oracle versions V7.1 on the main server and V7.3 (PO7) as snapshot clients. Refresh is somewhat erratic but I found using SNAPSHOT logs allows the fast refresh to work well. I'd be interested to hear, if V7.3 makes a big difference in reliability.

Sanjay T Mathew wrote in message <353E48BB.E25D62DD_at_micro.lucent.com>...
>The reason we are not using Oracles replication option is :
>
>We want to replicate a tables from one production site
>to a production site and a training site.
>In the past we have faced problems that when one snapshot site had
>a broken link then to resolve the problem we had to rebuild the snapshots
>at all the sites. In the current scenario if there is a problem with the
>snapshot at the training site we do not want to affect the production
>snapshot by rebuilding it just because the training snapshots are affected.
>This is especially true when the tables to be replicated are huge.
>We are using oracle 7.1.6 on the production site , i do not know
>if this problem has been fixed in 7.3.
>
>Your comments are appreciated.
>
>rono_at_fl.envworld.com wrote:
>
>> Is there some reason you are not considering Oracle's advanced
 replication
>> option? It is still tricky to set up, but is bundled with your Oracle
>> license.
>>
>> -- Ron Olcott, President
>> --
>
Received on Tue Apr 28 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US