Home » RDBMS Server » Server Administration » Unable to drop the user using the system login
Unable to drop the user using the system login [message #193780] Tue, 19 September 2006 06:52 Go to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Dear All,

I am getting the following error while trying to drop an user. Can somebody help on this?

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


Regards,
Antony
Re: Unable to drop the user using the system login [message #193792 is a reply to message #193780] Tue, 19 September 2006 07:33 Go to previous messageGo to next message
aorehek
Messages: 52
Registered: August 2006
Member

DROP USER user_name cascade;
Re: Unable to drop the user using the system login [message #193796 is a reply to message #193792] Tue, 19 September 2006 07:49 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
I have already tried the cascade command. Even that is giving the same error.
Re: Unable to drop the user using the system login [message #193922 is a reply to message #193796] Tue, 19 September 2006 23:35 Go to previous message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
This error occurs for all the users. Guess a base table referred to while dropping the user is missing. Can somebody let me know which table it could be ?
Previous Topic: Upgrade from Oracle9.0.1.0 to 9.2.0.7
Next Topic: Switching Logfile
Goto Forum:
  


Current Time: Sat Dec 03 16:26:58 CST 2016

Total time taken to generate the page: 0.06928 seconds