Unable to drop a table
Gurus,
In 11gR2, RHEL 4, Im getting the following err message.
I tried to drop the individual objects and indexes belongs to ggate owner, but still getting the same error.
SYS>drop user ggate cascade;
drop user ggate cascade
*
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 iin use
Please help me out on this!
Thanks,
Harry
0