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

Error:

SQL> Drop table test_temp;
Drop table test_temp
*
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use

Cause
While try to drop the temporary table, it is having data and may be other session is using it.

Solution
1. Before dropping the Temporary table make it empty or truncate it.

Truncate table temp;

2. Try the Drop command after make it empty from all session using this global temporary table.

Drop table temp;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.