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

Oracle error message numbers and Oracle error codes.
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:

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

Post by jimb »

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.
Oracle Database Administration Forums
http://www.oracle-forums.com/
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

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

Post by xaeresis »

Post Reply