RE: Droping System User

Hi all ,
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

Please , can anybody explain to me why I am getting this error ?

Regards

> -----Original Message-----
> From: Nirmal Kumar Muthu Kumaran [SMTP:NIRMALK_at_qtel.com.qa]
> Sent: Saturday, October 20, 2001 12:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Droping System User
>
> hi ....
>
> I took risk in my test DB by dropping the user 'SYSTEM'. As you tested,
> the same steps i repeated in mine, all are fine, until before.
>
> Now i shutdown my database and startup again, here the problem arises.
> Oracle mount the database but while opening the database, the instance has
> been terminated by PMON.
>
> Sat Oct 20 10:57:45 2001
> PMON: terminating instance due to error 470
> Instance terminated by PMON, pid = 316
>
> Oracle posted the following error continuosly in the alert log:
>
> SMON: following errors trapped and ignored:
> ORA-00376: file 1 cannot be read at this time
> ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF'
>
> Am crusious, come to know what type of problem you have faced?....
>
> Regards,
> Nirmal
>
> -----Original Message-----
> From: Jacques Kilchoer [SMTP:Jacques.Kilchoer_at_quest.com]
> Sent: Friday, October 05, 2001 12:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Droping System User
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [ < <mailto:Jared.Still_at_radisys.com>>]
> >
> > Dropping the SYSTEM user is not really all that traumatic.
> >
> > In most cases it's just a DBA account that may own some pieces you'd
> > rather not lose, but dropping SYSTEM will not be noticed by the users
> > of the database.
>
>
> That's the impression I get. When I looked at the objects owned by SYSTEM
> in my test database before the drop, none of them seemed vital.
>
> On the other hand, dropping sys would probably be bad, but I wasn't able
> to do that (insufficient privileges.)
> Trying to drop sys tables like sys.user$ caused an ORA-00701.
> So since I'm on a quest to wound this database, I tried this:
>
> SQL> delete from sys.user$ where name = 'SYS' ;
> 1 ligne supprimée.
> SQL> commit ;
> Validation effectuée.
>
> So far no ill effects!
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ahmed Gholam Hussain
  INET: ahussain_at_gisqatar.org.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).