Home » SQL & PL/SQL » SQL & PL/SQL » to drop a user
to drop a user [message #328307] Thu, 19 June 2008 13:05 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi to all,

When i try to drop a user using this command. I receive the following error

DROP USER "db_user" CASCADE

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


i have a schema named db_user. What is the problem


Thanks in Advance,

Seenu
Re: to drop a user [message #328310 is a reply to message #328307] Thu, 19 June 2008 13:09 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

I am sorry to see that GOOGLE is broken for you

Results 1 - 10 of about 788 for oracle drop user cascade ORA-00604: error occurred at recursive SQL level 1.

Please be patient while repairs are underway.
Additional information will be posted as it becomes available.

[Updated on: Thu, 19 June 2008 13:12] by Moderator

Report message to a moderator

Re: to drop a user [message #328316 is a reply to message #328307] Thu, 19 June 2008 13:34 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has been asked and answered many times here, so search here you'll soon get the answer.

Regards
Michel
Previous Topic: Trigger for calling same procedure for different column updation in a tabel
Next Topic: Equivalent of dateadd(MS Acess) in oracle
Goto Forum:
  


Current Time: Wed Dec 07 20:13:55 CST 2016

Total time taken to generate the page: 0.11505 seconds