Message-Id: <10576.113514@fatcity.com> From: "Rivera, Claudia" Date: Tue, 1 Aug 2000 13:49:21 -0600 Subject: RE: ORA-00054 thanks! -----Original Message----- From: Durinda.Jones [mailto:Durinda.Jones@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 Tech. Media Coordinator crivera@utep.edu http://dmc.utep.edu -- Author: Rivera, Claudia INET: crivera@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@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: Durinda.Jones INET: Durinda.Jones@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@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