ORA-00054:资源正忙,要求指定NOWAIT

SQL> select session_id from v$locked_object;如果遇到ORA-00942 表或视图不存在，请用管理员账号登录SESSION_ID8SQL> SELECT si

SQL> select session_id from v$locked_object;

如果遇到ORA-00942 表或视图不存在，请用管理员账号登录

SESSION_ID
8

SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 8;

SID	SERIAL#	USERNAME	OSUSER
8	35235	SCOTT	LILWEN

SQL> ALTER SYSTEM KILL SESSION '8,35235';System altered

然后就可以了