Showing posts with label alter or drop an index on temporary table already in use. Show all posts
Showing posts with label alter or drop an index on temporary table already in use. Show all posts

Saturday, 17 March 2012

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.