Re: What is a distributed transaction?

From: tmgn <tmgn_at_excite.com>
Date: Wed, 7 Jul 1999 13:48:59 -0400
Message-ID: <7m044b$ev7$1@ffx2nh3.news.uu.net>

Any transaction(DML) that involves more than One DB may be called as a Distibuted Transaction..

-Thiru

<amerar_at_ci.chi.il.us> wrote in message news:7m006e$hpt$1_at_nnrp1.deja.com...
>
>
>
> Hello,
>
> I recently set up a database link to a remote database. When I try to
> query it, I get the following message:
>
> ORA-2042 Too many distributed transaction.
>
> After about 2 hours I finally figured that the REMOTE database needed
> the DISTRIBUTED_TRANSACTIONS parameter.
>
> My question is, what is a distributed transaction and how does Oracle
> decide when a transaction is distributed and when it is not???
>
> Please cc a copy to e-mail......
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
> Oracle Database Administrator
> Department of Revenue
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jul 07 1999 - 12:48:59 CDT