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

IMG-00861: assert failure, inconsistency in area merge operation

1 Answers  


ORA-02714: osnpwr: message send failure

1 Answers  


RMAN-20004: target database name does not match name in recovery catalog

1 Answers  


ORA-01085: preceding errors in deferred rpc to "string.string.string"

1 Answers  


EXP-00099: Table "string"."string" is not in a valid state, table will not be exported

1 Answers  






ORA-24304: datatype not allowed for this call

1 Answers  


NNL-00013: not performed, permission denied for supplied password

1 Answers  


SQL*Loader-00624: no terminator found after TERMINATED and ENCLOSED field

2 Answers  


ORA-16572: Data Guard configuration file not found

1 Answers  


ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.

1 Answers  


RMAN-07000: List of SPFILE Backups

1 Answers  


ORA-19616: output filename must be specified if database not mounted

1 Answers  


Categories