Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00054
but no-one is using it?
I have even checked in the server processes and I see no one using it.
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Tuesday, August 01, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-00054
It means that someone else is accessing the table and the table and you will
have to try again when noone is using it. Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, August 01, 2000 11:05 AM
> I need to erase some rows from a table. But when I try to do it, nothing
> happens.
> The system just hangs in there until I press Ctrl C to stop it.
>
> Now, I tried to drop the table, and it gave me the following error:
>
> ORA -00054 Resource busy and acquire with NOWAIT specified.
>
> What does this mean??
>
> This is the only table with this type of problem.
>
> Everything else works fine.
>
> TIA
>
> --------------Claudia Rivera-----------------
> The University of Texas at El Paso
> Tech. Media Coordinator
> crivera_at_utep.edu
> http://dmc.utep.edu
>
>
> --
> Author: Rivera, Claudia
> INET: crivera_at_utep.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Aug 01 2000 - 14:47:29 CDT