<div>
Thanks a lot!!<br />
I learned a tip today!!!
</div>


<div>
<div class="content wysiwyg-content">
Dear experts:<br />
<br />
I was trying to run a PL/SQL anonymous block. It took too long because I forgot to put WHERE clause in the UPDATE statment. &nbsp;So I killed the session in the middle. <br />
<br />
Now I go back to check the table, truncate the table or drop the table, I got the error message:<br />
ORA-00054: resource busy and acquire with NOWAIT specified<br />
<br />
How can I solve it?<br />
<br />
Thanks a lot!!<br />

</div>
</div>


Dear experts:

I was trying to run a PL/SQL anonymous block. It took too long because I forgot to put WHERE clause in the UPDATE statment.  So I killed the session in the middle. 

Now I go back to check the table, truncate the table or drop the table, I got the error message:
ORA-00054: resource busy and acquire with NOWAIT specified

How can I solve it?

Thanks a lot!!


ORA-00054: resource busy and acquire with NOWAIT specified

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.