Table lock [message #35714] |
Tue, 09 October 2001 07:58 |
Gloria Zhao
Messages: 11 Registered: October 2001
|
Junior Member |
|
|
Hi There,
I put an lock table stmt in my pl/sql scripts. But I am wondering what is the syntax to release the lock. The lock I put is like 'lock table tname in exclusive mode'.
Thanks for your help.
Gloria
----------------------------------------------------------------------
|
|
|
Re: Table lock [message #35715 is a reply to message #35714] |
Tue, 09 October 2001 08:34 |
Vani
Messages: 13 Registered: October 2001
|
Junior Member |
|
|
You can disable the lock by using this command.
ALTER TABLE tablename DISABLE|ENABLE TABLE LOCK
----------------------------------------------------------------------
|
|
|