oracle 可以drop 表锁,删除oracle表被锁住

运行一程序，用户把表给锁住，下面给出解决方案：[@more@]

首先先查出SID，

SELECT SUBSTR(all_objects.owner||'.'||object_name,1,16) "Locked Object"

,SUBSTR(os_user_name,1,10) "Tiptop User"

,v$locked_object.process "Proc ID"

,SUBSTR(terminal,1,7) "Terminal"

,v$session.sid,v$session.serial#

,v$session.machine

FROM v$locked_object,all_objects,v$session

WHERE v$locked_object.object_id=all_objects.object_id

AND v$locked_object.SESSION_ID=v$session.SID

查出SID，

然后在sqlplus '/as sysdba'

alter system kill session 's_id,session_id';

找出相关的sid,sessionid,然后一一删除！

用户重新运行程序，解锁成功！