Re: Distributed Transactions and Two-Phase Commit

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Mar 2005 16:29:18 -0800
Message-ID: <1111624158.803732.219440@z14g2000cwz.googlegroups.com>

With both versions 9.2 and 10g the DBA Administration Guide contains several chapters on distributed processing. The Oracle rdbms background process, reco, handles resolution of failed distributed transactions.

Synonyms are not technically necessary for distributed transactions since you can just code the remote owner.object_name_at_link in your SQL; however, providing synonyms for remote objects makes codeing distributed transactions easier for developers and end-users while providing location transparity.

HTH -- Mark D Powell -- Received on Wed Mar 23 2005 - 18:29:18 CST