Re: ORA-00054

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 01 Aug 2000 13:32:27 -0400
Message-Id: <10576.113504@fatcity.com>

you did not state "how many rows" were being deleted. If the count of rows = deleted was large there could be a lot of roll back segments that have to = be applied before the resource is released. It should take approx the same = amount of time to rollback as it did during the delete. The resourse is = being locked by the rollback because you killed the process CTRL-C. Ron Rogers
DBA OCP
Atl.GA

>>> crivera_at_utep.edu 08/01/00 11:05AM >>>
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=20
http://dmc.utep.edu=20

--=20
Author: Rivera, Claudia
  INET: crivera_at_utep.edu=20

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 - 12:32:27 CDT