Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00054: resource busy and acquire with NOWAIT specified

From: cumin <jkilbourne_at_gmail.com>
Date: 6 Oct 2005 09:22:08 -0700
Message-ID: <1128615728.674757.165980@g44g2000cwa.googlegroups.com>


A table was updating, taking far longer than I expected. In sql*plus, I hit Ctl-C to abort the update, but was exited out of sql*plus as well. I then tried to modify the table (to remove a column), and received

ORA-00054: resource busy and acquire with NOWAIT specified

I had never specified NOWAIT (I don't even know what NOWAIT does). I executed "commit" thinking that would take care of it, and Oracle would give me back control of the table, but that didn't work. I moved the data to another table and tried to drop the original table, but again received the error. I'm not even sure if exiting Oracle in the middle of the update related to this error.

How can I drop this table? Received on Thu Oct 06 2005 - 11:22:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US