Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-00054: resource busy and acquire with NOWAIT specified
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