Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-19648: datafile string: incremental-start SCN equals checkpoint SCN

1 Answers  


ORA-01987: client os username is too long

1 Answers  


PLS-00668: Type of expression should be a collection type

1 Answers  


DRG-11609: URL store: unable to open local file specified by string

1 Answers  


ORA-32812: subscriber string does not exist

1 Answers  






ORA-07721: scgcm: not enough OS resource to obtain system enqueue

1 Answers  


ORA-15033: disk 'string' belongs to diskgroup "string"

1 Answers  


ORA-29517: recursive resolution failed for a referenced class

1 Answers  


PCC-00117: Invalid ARRAYLEN length variable type

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  


ORA-31043: Element 'string' not globally defined in schema 'string'

1 Answers  


RMAN-06142: DEVICE TYPE cannot be specified with this command

1 Answers  






Categories