Oracle Error: ORA-00054: The resource is busy and requires the specified NOWAIT

Http://www.cnblogs.com/Ronger/archive/2011/12/19/2293509.html

The problem is as follows:

Sql> Conn Scott/[email Protected]_database
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
Connected as Scott

。。。。。。

sql> drop table Student2;

drop table Student2

ORA-00054: The resource is busy, but the resource is specified as NOWAIT, or the timeout expires
=========================================================

Here's how to fix it:

=========================================================

Sql> select session_id from V$locked_object;

session_id
----------
142

sql> SELECT SID, Serial#, username, osuser from v$session where sid = 142;

SID serial# USERNAME Osuser
---------- ---------- ------------------------------ ------------------------------
142 SCOTT Lilwen

sql> ALTER SYSTEM KILL SESSION ' 142,38 ';

System Altered

Oracle Error: ORA-00054: The resource is busy and requires the specified NOWAIT