Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-14452 attempt to create, alter or drop an index on temporary table

orauser34Apr 27 2011 — edited May 2 2011
Hi,

How can we drop a Global Temporary Table?

I get the below mentioned error messsage when I try to drop a Global Tempary table :
"ORA-14452: attempt to create, alter or drop an index on temporary table already in use"

I have tried closing all my sessions and even removing the reference of the global temporary table from my procedure but still get the same error.

Any help is appreciated.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2011
Added on Apr 27 2011
9 comments
42,776 views