RE: Droping System User

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 22 Oct 2001 10:45:58 -0700
Message-ID: <F001.003B195D.20011022104540@fatcity.com>

> -----Original Message-----
> From: Ahmed Gholam Hussain [mailto:ahussain_at_gisqatar.org.qa]
>
> 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. Received on Mon Oct 22 2001 - 12:45:58 CDT