Unfortunately, using dbms_lock you can release only user locks, which are
different from usual row and table locks. Also, releasing lock means
rollback of user transaction and therefore returning an error message to an
appliction. May be that is why there isn't mean to release a lock
explicitly.
Paul wrote <369745ee.537258_at_news.tcp.co.uk> ...
>On Sat, 09 Jan 1999 02:28:37 GMT, robertch_at_mindspring.com (Robert
>Chung) wrote:
>
>>I can find out which object in database is locked by which user by
>>taking a look at v$locked_object and dba_objects views, but I do not
>>know how to unlock that object. Is there any wayfor DBA to unlock
>>those objects locked by other users? So far I have been just killing
>>their session to unlock those objects. (oh, silly.) Thanks in
>>advance.
>>
>Look at DBMS_LOCK utils, it has various lock processing functions
>including a lock release function.
>
>Paul
>aspscott_at_tcp.co.uk
>^^ remove 'as' anti spam prefix to reply
>
Received on Sat Jan 09 1999 - 15:00:13 CST
