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



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

Answer / guest

Cause: An attempt was made to create, alter or drop an index
on temporary table which is already in use.

Action: All the sessions using the session-specific
temporary table have to truncate table and all the
transactions using transaction specific temporary table have
to end their transactions.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.

1 Answers  


ORA-02781: Invalid value given for the timing wanted flag

1 Answers  


ORA-29846: cannot create a local domain index on a string partitioned table

1 Answers  


ORA-30647: error retrieving access parameters for external table string.string

1 Answers  


EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  






ORA-08112: a composite partition may not be coalesced as a whole

1 Answers  


ORA-30205: invalid Character set

1 Answers  


ORA-22856: cannot add columns to object tables

2 Answers  


PLS-00238: external parameter name string not found in formal parameter list

1 Answers  


ORA-19037: XMLType result can not be a fragment

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


ORA-00283: recovery session canceled due to errors

1 Answers  


Categories