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
> 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.
> -----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.