AQ is messaging functionality for Non-Oracle databases AND Oracle database. The reason you need it in this case is to take away some admin/management a= ctivities. The way I read your requirements is that you want a local program to comple= te correctly regardless of the status of the remote database.
It therefore makes sense to make the part of your program that deals with t= he remote database a two-phase one.
EG, (A) insert into the local table.=20 (B) enqueue an AQ message to be asynchronously picked up and pushed to the = remote DB.
Using AQ for the remote task means simple admin tasks like handling queue e= xceptions and=20 attempting retries can be taken care of.
Nick -- --Original Message-- -- From: Sami Seerangan [mailto:dba.orcl@(protected)] Sent: 16 February 2005 14:40 To: Mercadante, Thomas F; Nick Tilbury @ Northampton Cc: oracle-l@(protected) Subject: 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@(protected)> wrote: > Sami, >=20 > The problem is that Oracle is still holding the update to the remote > database open. Try the following: >=20 > You could also look at using savepoints. Nick had a good idea also about > looking at Advanced Queueing. >=20 > Tom >=20 >=20 > -- --Original Message-- -- > Hi All, >=20 > 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. >=20 >
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D This message is intended solely for the use of the individual or organisati= on to whom it is addressed. It may contain privileged or confidential info= rmation. If you have received this message in error, please notify the ori= ginator immediately. If you are not the intended recipient, you should not= use, copy, alter, or disclose the contents of this message. All informati= on or opinions expressed in this message and/or any attachments are those o= f the author and are not necessarily those of VarTecTelecom Europe Ltd or i= ts affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss= or damage arising from its use, including damage from virus.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D
