| Unable to drop user [message #58347] |
Mon, 18 August 2003 00:51  |
Nagesh
Messages: 18
Registered: April 2002
|
Junior Member |
|
|
Hi,
Please help me to drop the user. I have connected to that user and drop all schema objects .. still i am getting the same error.(Oracle 8.1.7 database)
==================================
SQL> DROP USER AIRTEL CASCADE;
DROP USER AIRTEL CASCADE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
|
|
|
|
|
|
| Re: Unable to drop user [message #58352 is a reply to message #58349] |
Mon, 18 August 2003 03:52  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi Shesha
Looks like there is problem with your data dictionary,
are you facing similar problems for the rest of users too. If So U have to run catalog.sql and catproc.sql once again. Otherwise U drop all the objects associated with that user manually.
Thanks and Regards
Prasad
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
