All geek questions in one place

ORA-00054 Resource is busy dropping table

Can someone explain this error. ORA-00054 Resource is busy and is being implemented using NOWAIT ...

This error occurred while expanding the table. bcoz of this procedure and packages are not compiled.

+4
source share
2 answers

ORA-00054 means that another session has a database object lock that completely prevents our action.

Your script that you present is confused, but basically someone has a lock on the table - maybe they execute XML against DML, and you won’t be able to drop it until they release this lock (i.e. commit or rollback )

Having said everything, I'm not sure why you want to drop the table in order to fix the PL / SQL compilation problem. You should review your question to give us a clearer picture of what you are trying to achieve.

+10
source

you may have a query or task running against a table. your objects cannot be recompiled or deleted until long requests / tasks are completed. In addition, you can kill any sessions except yours, and then continue compiling.

+2
source

Source: https://habr.com/ru/post/1340939/

More articles:


All Articles