Hi,
See TWO PHASE COMMIT comes in Distributed Database System.In Two phase Commit all the database servers in distributed database either commit or rollback as a unit.

For e.g Say u are running a transaction which updates 3 databases.So incase if one database is not able to commit the transaction,the other databases will also not commit the transactions.So there is data integrity in distributed database system.Oracle automatically performs TWO PHASE COMMIT.

In case of any help needed please be free to ask me at [email protected]


Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]