ORA-14452: attempt to create, alter or drop an index on temporary table already in use

ORA-14452: attempt to create, alter or drop an index on temporary table already in use


Cause:


An attempt was made to create, alter or drop an index on temporary table which is already in use.



Action:


All the sessions using the session-specific temporary table have to truncate table and all the transactions using transaction specific temporary table have to end their transactions.