OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Unable to Drop User (Oracle 10g Rel 2 Linux 5)

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

Unable to Drop User [message #510553]

Mon, 06 June 2011 07:31

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

Dear All,

Im facing the problem whenever I try to drop a user..
follwing thing that I m trying..

system@vahan> drop user knp cascade;

Error at line 1:
ORA-00604: error occured at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7

Any help is appreciated.

Regards,
Sudhanshu

Report message to a moderator

Re: Unable to Drop User [message #510554 is a reply to message #510553]

Mon, 06 June 2011 07:32

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

You've probably got a DDL trigger on drop user that's causing the error.

Report message to a moderator

Re: Unable to Drop User [message #510559 is a reply to message #510553]

Mon, 06 June 2011 07:42

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select owner, trigger_name, status 
from dba_triggers 
where triggering_event like '%DROP%' 
order by 1, 2
/

Regards
Michel

Report message to a moderator

Re: Unable to Drop User [message #510696 is a reply to message #510559]

Tue, 07 June 2011 05:02

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

Thanks for the reply..
IT HAS ONE TRIGGER ENABLED AS GIVEN BELOW:
SYS SDO_DROP_USER ENABLED
i DISABLED IT AND IT WORKED.....

THANKS SO MUCH.....
BUT I CANT FIGURED IT OUT HOW IT GETS ACTIVATED....
????

Report message to a moderator

Re: Unable to Drop User [message #510699 is a reply to message #510696]

Tue, 07 June 2011 05:14

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Do not post in upper case - it is considered shouting on internet forums (not just this one)
2) Can't figure out how what gets activated exactly? A trigger on drop will fire whenever you try to drop something.

Report message to a moderator

Previous Topic:	Minimum datafile size
Next Topic:	MAXEXTENTS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 20:31:12 CDT 2024