posted 16 years ago
Hi All,
I created some users and now I am not able to drop them as system user also. Though I'm able to drop the tablespaces.
Its throwing below errors:
SQL> drop user amr cascade;
drop user amr cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
What could be wrong with database settings or any other params required???
Thanks,
-Ricky
Regards, Ricky
Oracle Weblogic 10g Certified Expert TechPaste.Com