OraFAQ Forum: Forms » SQL*PLUS transaction exited what happens

Home » Developer & Programmer » Forms » SQL*PLUS transaction exited what happens

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*PLUS transaction exited what happens [message #82677]

Sun, 22 June 2003 02:19

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.
:-)

Report message to a moderator

Re: SQL*PLUS transaction exited what happens [message #82688 is a reply to message #82677]

Mon, 23 June 2003 05:19

Maaher
Messages: 7065
Registered: December 2001

Senior Member

See the docs.

MHE

Report message to a moderator

Re: SQL*PLUS transaction exited what happens [message #82689 is a reply to message #82677]

Mon, 23 June 2003 05:29

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

Report message to a moderator

Re: SQL*PLUS transaction exited what happens [message #82698 is a reply to message #82688]

Tue, 24 June 2003 00:34

Sun
Messages: 92
Registered: August 2002

Member

In CAse of NT, in server u can kill the session.

Then it will allow to proceed...

Report message to a moderator

Re: SQL*PLUS transaction exited what happens [message #83554 is a reply to message #82677]

Sun, 26 October 2003 23:52

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:27:53 CDT 2024