OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Unable to drop user (10.2.0.3 Enterprise edition)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to drop user [message #582544]

Fri, 19 April 2013 06:13

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

Report message to a moderator

[Message index]

		Unable to drop user By: AnilKampiri on Fri, 19 April 2013 06:13
		Re: Unable to drop user By: Littlefoot on Fri, 19 April 2013 06:23
		Re: Unable to drop user By: Roachcoach on Fri, 19 April 2013 08:44
		Re: Unable to drop user By: Michel Cadot on Fri, 19 April 2013 09:08
		Re: Unable to drop user By: AnilKampiri on Fri, 19 April 2013 09:52
		Re: Unable to drop user By: Michel Cadot on Fri, 19 April 2013 09:55
		Re: Unable to drop user By: AnilKampiri on Fri, 19 April 2013 09:59
		Re: Unable to drop user By: Michel Cadot on Fri, 19 April 2013 10:12
		Re: Unable to drop user By: AnilKampiri on Mon, 22 April 2013 08:13
		Re: Unable to drop user By: Michel Cadot on Mon, 22 April 2013 08:19
		Re: Unable to drop user By: Roachcoach on Mon, 22 April 2013 08:20
		Re: Unable to drop user By: AnilKampiri on Mon, 22 April 2013 08:26
		Re: Unable to drop user By: Michel Cadot on Mon, 22 April 2013 08:26
		Re: Unable to drop user By: Roachcoach on Mon, 22 April 2013 08:45
		Re: Unable to drop user By: AnilKampiri on Mon, 22 April 2013 09:13
		Re: Unable to drop user By: Roachcoach on Mon, 22 April 2013 09:48
		Re: Unable to drop user By: ashwani0301 on Mon, 22 April 2013 10:09
		Re: Unable to drop user By: Michel Cadot on Mon, 22 April 2013 10:20
		Re: Unable to drop user By: nlnkapardi on Tue, 23 April 2013 02:31
		Re: Unable to drop user By: Michel Cadot on Tue, 23 April 2013 02:58

Previous Topic:	about oracle database 9i
Next Topic:	pga_aggregate_target

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:31:31 CDT 2024