Oracle-L: RE: ORA-02050

From: <John.Hallas_at_vodafone.co.uk>
Date: Tue, 05 Nov 2002 06:33:44 -0800
Message-ID: <F001.004FBB91.20021105063344@fatcity.com>

Ray,
I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that.
Of course if there is nothing in that table then the transaction has been rolled back already

John

-----Original Message-----
Sent: 05 November 2002 13:43
To: Multiple recipients of list ORACLE-L

ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt

The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer?

Thanks.

Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ray Stell
INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------