Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Replication Question
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
![]() |
![]() |