Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP Can't drop tables

Re: HELP Can't drop tables

From: Randy A. Stebbins <Randys_at_triax.com>
Date: 1997/03/17
Message-ID: <332E13DA.2BB9@triax.com>#1/1

> What does this mean? I cant use it or drop it.
>
> SQL> drop table john_temp;
> drop table john_temp
> *
> ERROR at line 1:
> ORA-00054: resource busy and acquire with NOWAIT specified

It means that someone (or you, in another session) has the table locked.  You will need to wait until the lock is released before you can drop the table. Received on Mon Mar 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US