René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

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

This error occurs when it is tried to perform a DDL on a global temporary table with on commit preserve rows when the session trying to do the DDL has already made a DML on the table.
In order to do a DDL, the table must first be either truncated or the session must be exited.