Re: remote date transfer

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 18 Nov 1999 00:33:09 -0800
Message-ID: <3833B9C5.FC62F5F6@us.oracle.com>

OK, so what's the issue with using snapshots? If you are doing this continuously, you can either do it synchronously using triggers, or asynchronously using snapshots. The problem with the synchronous approach is that an insert into the source table can fail because the trigger fails when the network is down. The problem with snapshots is that the data may be temporarily out of synch between the two systems. What are the business needs you're trying to meet?

Pete

narayan wrote:

> thanks for your reply
> what u said is right
> the data transfer will be continious dynamic
> we want to use triggers to do that..
> problem seems to be that the instance name in both the databases is same
> thanks again
> narayan
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu Nov 18 1999 - 02:33:09 CST