I got the following err msg when i tried to drop a table.
ORA-00054: resource busy and acquire with NOWAIT specified.
Can anyone let me know that what would be the reason.
Thanx in advance.
RTM ( Concepts and Error Messages )
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
When the resource (Table) is being used by other sessions, you tried to drop the table. That is why you got 54 error.
To avoid the error, you first lock the table in exclusive mode, and then drop it.
SQL> lock table t1 in exclusive mode ;
SQL> drop table t1;
Click Here to Expand Forum to Full Width