ORA-14452: attempt to create, alter or drop an index on temporary table already in use.
Recently, on our 11g-Database (production server)
Whenever we give the commands for creation of Column in a Table or dropping of Tables (irrespective of the SCHEMAS we work in), we get the error:
ORA-14452: attempt to create, alter or drop an index on temporary table already in use.
we used TOAD as well as Putty's SQL prompt and issued the command :
to Drop a Table we used the command:
SQL> drop table ESE_BR_PDT_PRIM_DATA;
or to add column we used the command:
SQL> Alter TABLE LGGSM.GSM_REPORTBASE_TABLE add(PREVIOUS_RD_NAME VARCHAR2(100));
While we have checked that the TEMP tablespace is 100% FREE, while UNDO_Tablespace is also 25% FREE, we fail to understand why this error occurs and why oes it not allow us to alter or drop a TABLE ?