In this post, you’ll learn more about the Oracle ErrorORA-14452: attempt to create, alter or drop an index on temporary table already in use with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
Reason for the Error ORA-14452: attempt to create, alter or drop an index on temporary table already in use
An attempt was made to create, alter or drop an index on temporary table which is already in use.
How to fix the Error ORA-14452: attempt to create, alter or drop an index on temporary table already in use ?
You can fix this error in Oracle by following the below steps
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.