What is a distributed transaction?

From: <amerar_at_ci.chi.il.us>
Date: Wed, 07 Jul 1999 16:45:07 GMT
Message-ID: <7m006e$hpt$1@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 - 11:45:07 CDT