Home » SQL & PL/SQL » SQL & PL/SQL » unlock table in oracle 8i sqlplus urgent
unlock table in oracle 8i sqlplus urgent [message #195678] Sun, 01 October 2006 02:16 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
i lock a table in oracle 8i by

lock table emp in exclusive mode;


now i unlock this table

pls help

Re: unlock table in oracle 8i sqlplus urgent [message #195679 is a reply to message #195678] Sun, 01 October 2006 02:43 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Do a COMMIT or ROLLBACK.
Re: unlock table in oracle 8i sqlplus urgent [message #195680 is a reply to message #195679] Sun, 01 October 2006 02:47 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,

If commit or Rollback does not work, look at this releated question on this site answered by FRANK ,
http://www.orafaq.com/forum/m/173925/82337/?srch=unlock+table#msg_173925


Regards
Re: unlock table in oracle 8i sqlplus urgent [message #195740 is a reply to message #195680] Mon, 02 October 2006 01:51 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The answer you refer to was how to get rid of a lock held by another, unknown, session.
This question is ' How do I get rid of a lock held by my session.'

If you can show me an example where a commit or rollback can fail to clear a lock like the one in the OP, then I'll eat my hat.
Previous Topic: convert From week to date
Next Topic: TYPE VARRAY - Insert
Goto Forum:
  


Current Time: Tue Dec 06 04:16:07 CST 2016

Total time taken to generate the page: 0.09310 seconds