ORA-00054 删除表时资源繁忙
有人可以解释这个错误吗？
ORA-00054: 资源繁忙并指定 NOWAIT 获取
此错误出现在 DROP TABLE 中。因此，过程和包不会被编译。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
ORA-00054表示其他某个会话锁定了数据库对象，这会阻止我们的操作完全成功。您呈现的场景有点混乱，但基本上有人在表上有锁 - 可能他们正在针对它执行一些 DML - 并且您将无法删除它，直到他们释放该锁（即提交或回滚） ）。
说了这么多，我不确定为什么你想要删除一个表来修复 PL/SQL 编译问题。您应该修改您的问题，以便我们更清楚地了解您想要实现的目标。
ORA-00054means 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.
您可能有针对该表运行的查询或作业。在长时间运行的查询/作业完成之前，您的对象无法重新编译或删除。或者，您可以终止除您的会话之外的所有会话，然后继续编译。
you may have a query or a job running against the table. your objects cannot be recompiled or dropped until that long running queries/jobs are finished. Alternatively, you can kill any sessions except yours and then proceed with the compilation.