Cannot drop table in Oracle 8i

From: <whyme_at_nowhere.com>
Date: Wed, 12 Jun 2002 02:16:14 GMT
Message-ID: <pfbdgu4dbntmorao5gat2vndcev1ptnndu@4ax.com>

I have created a table in Oracle 8i, and now I am not able to drip it.

Here is the table I created:

CREATE TABLE LOCATION

(loc_id NUMBER(6),
bldg_loc VARCHAR2(15),
bldg_code VARCHAR2(20),

room VARCHAR2(6),
capacity NUMBER(5),
CONSTRAINT location_loc_id_pk PRIMARY KEY (loc_id));

When I type drop table location;

I get a message :

SQL> drop table location;
drop table location

           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

What do I have to do in order to drop it? The table contains no data. I am not even able to drop it through DBA Studio.

Thank You Received on Tue Jun 11 2002 - 21:16:14 CDT