Re: Cannot drop table in Oracle 8i

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

Your table is in use. Hence you can not perform any ddl on it. Search in v$db_object_cache who is using it.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Wed Jun 12 2002 - 02:21:33 CDT