Home » RDBMS Server » Server Administration » Unable to drop user (10.2.0.3 Enterprise edition)
Unable to drop user [message #582544] Fri, 19 April 2013 06:13 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Please note today we unable to drop user due to below error,Please advice how to drop the below user without shutdown the database.


SQL> drop user mvm_2010 cascade;
drop user mvm_2010 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
in use



Please note no session was availlable for particular user.

Regards,
Anil
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: about oracle database 9i
Next Topic: pga_aggregate_target
Goto Forum:
  


Current Time: Fri Jan 24 11:20:03 CST 2020