How to release table locked by KILLED session
420827May 5 2009 — edited May 5 2009Hi all,
Hi have problem in one of my table, i did delete of 12 millions rows from yesterday and it was not finished and i stopped the sqlplus and kill the session but till now the session is marked killed but the table is still locked and we can't do nothing in the table. We always get the error of resource busy and aquire nowait.
CDoes anybody can help me on how to release this table without restarting the database.
Thanks for the help because it's very urgent for us.
Raitsarevo