| 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
thanks!
-----Original Message-----
From: Durinda.Jones [mailto:Durinda.Jones_at_yellowcorp.com]
Sent: Tuesday, August 01, 2000 11:16 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-00054
Claudia,
It sounds like a process has a lock on some rows you're trying to delete. That's why you hang when you try the delete. Another process is updating the rows and hasn't issued a commit. This is also why you get the ORA-00054 when you try to delete the table. You need to find out what process has the lock and get them to either commit or rollback. It's possible it might be an orphan process that's never going to complete. In that case you will need to kill the session so it can rollback. Depending on how much that process was doing, rollback could take a while.
You can run the $ORACLE_HOME/rdbms/admin/utllockt.sql to see the blocking locks. Or, use the Lock Manager in OEM (my preferred way, but not everybody has that option).
Durinda Jones
Yellow Technologies
-----Original Message-----
Sent: Tuesday, August 01, 2000 10:05 AM
To: Multiple recipients of list ORACLE-L
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-LReceived on Tue Aug 01 2000 - 14:49:21 CDT
(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: Durinda.Jones INET: Durinda.Jones_at_yellowcorp.com 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
 |
 |