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;