IN ORACLE MILIEU …

Beyond Knowledge

Daily Archives: January 6, 2010

Unlocking the locked table

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 [...]

Follow

Get every new post delivered to your Inbox.

Join 130 other followers