I killed a script that was in the middle of updating a table. Now when I rerun the script I am getting,
ORA-00054: resource busy and acquire
with NOWAIT specified
I presume the table is locked?. How do I unlock the table?. Thanks in advance.
ora-00054oraclesqlunix
I killed a script that was in the middle of updating a table. Now when I rerun the script I am getting,
ORA-00054: resource busy and acquire
with NOWAIT specified
I presume the table is locked?. How do I unlock the table?. Thanks in advance.
Best Answer
Step 1:
Step 2:
More info: http://www.oracle-base.com/articles/misc/killing-oracle-sessions.php