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!!