ORA:00054 处理
ORA-00054: resource busy and acquire with NOWAIT specified对于这个问题解决,可以有两种方式:1)COMMIT or ROLLBACK will release locks of the current user
2)If its really locked and the commit suggestions don't work, get the SID and
SERIAL# fields from v$session and issue a ALTER SYSTEM KILL SESSION command.
This sometimes takes a while as Oracle has some cleaning up to do, but the
object is eventually freed.对于第二种方法,需要补充,执行步骤如下:a、以sysdba身份登陆数据库,connect ***/***@*** as sysdbab、从视图v$session中查找状态为inactive的SID,select status, sid, serial# from v$sessionc、使用命令kill状态为inactive的session,alter sysmen kill session '<sid>,<serial>'