Unlocking the locked tablePosted: 19/11/2010
Some times we get an error while running a DDL statement on a table. something like below
SQL> drop table aa; drop table aa * ERROR at line 1: ORA-14452: attempt to create, alter or drop an index on temporary table already in use
This happens because some other session is using this table or having a lock on this table.
Following is the simple procedure to kill the session holding the lock on this table and drop the table. Note that this should be done only if you are sure that this table is no more required and all sessions holding lock on this table can be deleted