| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00054
I am just trying to delete one row. I will check the locked processes to see
what I can do.
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: Tuesday, August 01, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-00054
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
-- 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: Ron Rogers INET: RROGERS_at_galottery.org 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:51:04 CDT
 |
 |