Distributed transaction warning

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Fri, 5 Feb 2010 09:43:39 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F040A3FF2_at_us-bos-mx022.na.pxl.int>

OK, all of you TOAD users/guru's out there, I've a user who is getting the following error message from TOAD that I can't pin down;

 "Auto Commit is disabled. A session that has pending transactions is about to close."

This happens whenever she looks at a view that is composed entirely of data from a second database. To make matters even more complicated the database that she's connected to is Oracle 10g R1 and the source db is 8.1.7. Now all she is doing is reading the data, no updated, deletes, even cut/paste not being used. Anyone got any idea about what is going on??

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
900 Chelmsford St, Suite 310
Lowell, MA 01821

The information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.

Received on Fri Feb 05 2010 - 08:43:39 CST

Original text of this message