Home » Developer & Programmer » Forms » SQL*PLUS transaction exited what happens
SQL*PLUS transaction exited what happens [message #82677] Sun, 22 June 2003 02:19 Go to next message
shashi
Messages: 34
Registered: March 2001
Member
Not sure if this question can be asked in this forum .
Any idea whats the answer to this question is?
When a transaction in being executed using SQL*PLUS tool and the tool is being closed down suddenly with out any commit or rollback given exclusively ,what will happen to the transaction
a)transaction is rolled back
b)transaction is commited
c)there wud be lock on the database resources used in this transaction.
d)none

Request you to give an explanation pls.
:-)
Re: SQL*PLUS transaction exited what happens [message #82688 is a reply to message #82677] Mon, 23 June 2003 05:19 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
See the docs.

MHE
Re: SQL*PLUS transaction exited what happens [message #82689 is a reply to message #82677] Mon, 23 June 2003 05:29 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
if u have not written any commit in between then it will commit. If u execute a single query, then that session will be killed it will not commit. But chances are there for locking. It depends
Re: SQL*PLUS transaction exited what happens [message #82698 is a reply to message #82688] Tue, 24 June 2003 00:34 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
In CAse of NT, in server u can kill the session.

Then it will allow to proceed...
Re: SQL*PLUS transaction exited what happens [message #83554 is a reply to message #82677] Sun, 26 October 2003 23:52 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
Hey the Transaction gets Rolled Back...
unless there is any explicit commit or any DDL statements given the transactions always gets Rolled Back....

Cheers
Ram
Previous Topic: Oracle 9iDS runtime URL
Next Topic: How can i lessen the time of millions of records to update
Goto Forum:
  


Current Time: Sat Aug 13 01:00:51 CDT 2022