Re: How to handle the exception when remote db is down

Thomas and Nick, Thanks for your responses.

AQ is to propagate messages to and from non-Oracle messaging systems.
Here I just interact with another oracle database thru distributed
transaction. Why do I need AQ in this place?


On Wed, 16 Feb 2005 08:37:23 -0500, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> Sami,
> 
> The problem is that Oracle is still holding the update to the remote
> database open.  Try the following:
> 
> You could also look at using savepoints.  Nick had a good idea also about
> looking at Advanced Queueing.
> 
> Tom
> 
> 
> -----Original Message-----
> Hi All,
> 
> I am trying to do DML activity on both local and remore DB. If the
> remote db is down, I need to insert the values into temporary table on
> the local db so that later when the remore db becomes available I can
> push the records.
> 
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: