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@(protected)> 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
