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-32159: Cannot set prefetch options for a null Type

1 Answers  


ORA-19003: Missing XML root element name

1 Answers  


ORA-06532: Subscript outside of limit

1 Answers  


ORA-32144: Cannot perform operation on a null interval

1 Answers  


DRG-10820: invalid contains cursor id

1 Answers  






ORA-25409: failover happened during the network operation,cannot continue

1 Answers  


ORA-29552: verification warning: string

1 Answers  


ORA-13607: The specified task or object string already exists

1 Answers  


ORA-32134: Cannot assign LOBs

1 Answers  


NNL-00529: set|show default_domain [<domain_name>] : set|show the current default domain

1 Answers  


RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


RMAN-06591: must specify TO PLATFORM

1 Answers  


Categories