RE: Distributed transaction warning
- From: "Joel Slowik" <jslowik@xxxxxxxxx>
- To: <Richard.Goulet@xxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Feb 2010 09:46:15 -0500
Is toad setup to run a script at startup or the like?
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Goulet, Richard
Sent: Friday, February 05, 2010 9:44 AM
To: ORACLE-L
Subject: Distributed transaction warning
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
978.614.2857
Richard.Goulet@xxxxxxxxxxx
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.
Confidentiality Note: This electronic message transmission is intended only for
the person or entity to which it is addressed and may contain information that
is privileged, confidential or otherwise protected from disclosure. If you have
received this transmission, but are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or use of the contents of
this information is strictly prohibited. If you have received this e-mail in
error, please contact Continuum Performance Systems at {203.245.5000} and
delete and destroy the original message and all copies.
Other related posts:
