ORA-14452: attempt to create, alter or drop an index on temporary table already in use
Error:
SQL> Drop table test_temp;
Drop table test_temp
*
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use
Cause
While try to drop the temporary table, it is having data and may be other session is using it.
Solution
1. Before dropping the Temporary table make it empty or truncate it.
Truncate table temp;
2. Try the Drop command after make it empty from all session using this global temporary table.
Drop table temp;