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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Replication Question

Re: Oracle 8i Replication Question

From: Anurag Varma <avoracle_at_gmail.com>
Date: 11 Jan 2006 12:44:44 -0800
Message-ID: <1137012284.911008.318270@f14g2000cwb.googlegroups.com>

Assuming this is multi-master replication that you are talking about:

I'd suggest the same as Frank:
use "dbms_reputil.replication_off" procedure to turn off replication in the session
doing the update. Thus you would
need to run the same update on both sessions with replication_off.

You are looking at a potential disaster if you try a 5 million row update and expect it to replicate. A single conflict will
ruin your day!

Apart from that: RTFM and look for "min_communication" and defining of column groups. That minimizes the amount of data sent over the network.

HTH Anurag Received on Wed Jan 11 2006 - 14:44:44 CST

Original text of this message

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