ORA-14452: attempt to create, alter or drop an index on temporary table
486215Mar 25 2009 — edited Mar 26 2009I am using Oracle 10.2.0.3 on Solaris 10.
I have locked a user couple of weeks back. I tried dropping this user now bIut faced this error
One of the tempfiles was dropped by a DBA but I don't find any usage of the objects from that schema in v$access table.
When I try dropping this user I face this error
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use
There are a few tables in this schema which I am not able to drop due to the previous error.
I tried truncating them and then issued drop command but that didn't help too.
I don't find any active transactions performed by this user . Any pointers will be of great help.