| 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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
