Re: Advanced Replication Question

From: Benjamin Zhang <bzhang_at_ei.org>
Date: Thu, 16 Jul 1998 10:39:42 -0400
Message-ID: <35AE10AE.D09C85A1@ei.org>

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
Received on Thu Jul 16 1998 - 09:39:42 CDT