Database Administration (MOSC)

MOSC Banner

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

edited May 7, 2010 6:43PM in Database Administration (MOSC) 4 commentsAnswered ✓
  Hello Experts,

 

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center