ORA-00054 Resource busy when dropping table

Question

Can somebody explain this error?

ORA-00054: Resource busy and aquire with NOWAIT specified

This error came in a DROP TABLE. Because of it, procedures and packages are not getting compiled.

Answer 1

ORA-00054 means some other session has a lock on a database object which prevents our action from completely successfully.

Your scenario as you present it is a trifle confused, but basically somebody has a lock on the table - probably they are xecuting some DML against it - and you won't be able to drop it until they release that lock (i.e. commit or rollback).

Having said all which I'm not sure why you'd want to drop a table to fix a PL/SQL compilation problem. You should revise your question to give us a clearer picture of what you're trying to achieve.