> -----Original Message-----
> From: Ahmed Gholam Hussain [mailto:[EMAIL PROTECTED]]
>
> I am unable to drop SYSTEM user in the first place ..I am
> getting this error
> while trying to drop it :
>
> SQL> drop user system cascade;
> drop user system cascade
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
If you really want to find out what is causing this error, try dropping all the objects owned by SYSTEM one by one, until you find the object that gives you that error message when you try to drop it.
