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

This error appears when you try to issue a DDL against a global temporary table thats created with “on commit preserve rows” clause.:- create global temporary table TEST (object_id number, object_name varchar2(30)) on commit PRESERVE rows; Such tables get bound to the session with the first insert and then this binding is ONLY removed when…