Home » SQL & PL/SQL » SQL & PL/SQL » Table lock
Table lock [message #35714] Tue, 09 October 2001 07:58 Go to next message
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 Go to previous message
Vani
Messages: 13
Registered: October 2001
Junior Member
You can disable the lock by using this command.
ALTER TABLE tablename DISABLE|ENABLE TABLE LOCK

----------------------------------------------------------------------
Previous Topic: Unix from Stored Procedure
Next Topic: Table name
Goto Forum:
  


Current Time: Sat May 25 03:13:15 CDT 2024