Re: Two phase commit.

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 2 Dec 2002 11:29:13 -0800
Message-ID: <asgca902sot@drn.newsguy.com>

In article <9306b3a3.0212021041.44a6d4d2_at_posting.google.com>, nova_dba_at_yahoo.com says...
>
>I have Oracle 9i testdb1 and testdb2 on Linux.
>
>
>Where can I find some information regarding what is two phase commit
>and how to implement? Is it hard to implement? Do I have to
>install/config Oracle differently? Does two phase commit happen in
>client level or at the server and how?
>
>Thanks your help in advance!
>
>Regards.

it is just:

commit;

nothing more, nothing less. If you have two (or n and n>1) databases, and you update data in more then one of them and issue "commit" - a two phase commit is initiated for you.

It just happens. You need do nothing to make it happen.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Dec 02 2002 - 13:29:13 CST