Home » SQL & PL/SQL » SQL & PL/SQL » Forcing Commit (Oracle 9i)
Forcing Commit [message #290127] Thu, 27 December 2007 10:33 Go to next message
bhuvan_oracle
Messages: 6
Registered: November 2007
Location: Chennai
Junior Member

Hi,

Any body explain me what is the use and give some practical usage of COMMIT FORCE.

Thank you
Bhuvan
Re: Forcing Commit [message #290129 is a reply to message #290127] Thu, 27 December 2007 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is used in distributed transaction when other sites are not reachable to cooperate to a normal 2 phase commit.
Then you decide to force the commit.

Database Concepts
Chapter 4 Transaction Management
Section Overview of Transaction Management
Subsection The Two-Phase Commit Mechanism

Regards
Michel
Re: Forcing Commit [message #290130 is a reply to message #290129] Thu, 27 December 2007 10:41 Go to previous message
bhuvan_oracle
Messages: 6
Registered: November 2007
Location: Chennai
Junior Member

Thank you Michel I will look into it.
Bhuvan
Previous Topic: embiding into an object
Next Topic: Return Table in a Function
Goto Forum:
  


Current Time: Tue Feb 18 01:39:21 CST 2025