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

After reading Hemant Sir's blog "GLOBAL TEMPORARY TABLEs and GATHER_TABLE_STATS " (http://hemantoracledba.blogspot.com/2011/01/global-temporary-tables-and.html) i tried the same on my system and again learned something new 🙂 Time to share it :). Session 1 --> Anand's session Session 2 --> SYS as sysdba Session 2 ========== 16:05:05 SYS@MATRIX> @session Username OSUSER SID SERIAL# SPID STATUS MODULE Term … Continue reading ORA-14452: attempt to create, alter or drop an index on temporary table already in use