Re: Cannot drop table in Oracle 8i

Some process has a lock of some sort on thattable, hence why you cannot drop it. If you have Enterprose manager, look at what is locking it.

M

whyme_at_nowhere.com wrote in message news:<pfbdgu4dbntmorao5gat2vndcev1ptnndu_at_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 Wed Jun 12 2002 - 07:42:07 CDT