Re: Advanced Replication Question

Actually, Oracle *used to* send over old/new images of the row, now in Oracle8 you can have it send only the neccessary values required for the operation you are doing (i.e. update or delete.)

If you are deleting based on Primary Keys, why not send a single statement? (e.g. where pk in (1,2,3,4).

-Frank

In article <35AE10AE.D09C85A1_at_ei.org>,
  bzhang_at_ei.org wrote:
> Hi Frank,
>
> I understand your frustration. But take a look at this situation:
>
> Two servers are in different time zone. If you pass the DML over, you will get
> different results. Actually, you case may be alright. But thinking of
> (sysdate - 10/86400) you may be in trouble. Also, if you use DML, you can not
> find out if the rows you deleted are the same on both servers. In replication,
> Oracle
> sends Old images over in deleting and make sure they match on both side. And
> could
> have other reasons Oracle selected use the stupid but safer way.
>
> ben
>
> nasof_at_hotmail.com wrote:
>
> > Hi all,
> >
> > Any one have any comments on this:
> >
> > I have an Asynchronous Multi-Master Replication setup with 2 NT server. One
> > is the Primary and the other is the Secondary (for failover.)
> >
> > A set of tables is replicated via one master group. The Primary database
> > (Oracle 8.0.4) keeps 7 days worth of active data. Every night, after
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 16 1998 - 16:18:40 CDT