RE: Droping System User

Hi JOE,

   The reason I posted this question in the list some time back was that this was one of tricky questions during one of my interviews( I do not know what was the senior DBA's goal asking this type of question ) I was amazed when I came to know that it can be droped ( I mean user SYSTEM )

Any way , let us be in safe side always ....

Regards
> -----Original Message-----
> From: JOE TESTA [SMTP:JTESTA_at_longaberger.com]
> Sent: Monday, October 22, 2001 8:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Droping System User
>
> i'm with you kimberly, but i some things, i guess just aint worth digging
> too deep into. Kinda like altering user$ to change a username instead of
> exp/imp.
>
> joe
>
>
> >>> kimberly.smith_at_gmd.fujitsu.com 10/22/01 12:15PM >>>
> Um, I have to disagree, although I must admit I will not try it. Its
> a good way for people to get used to backup and recover. And that is
> never a bad thing.
>
> -----Original Message-----
> Sent: Monday, October 22, 2001 5:11 AM
> To: Multiple recipients of list ORACLE-L
>
>
> So - why bother? Your having problems doing it - it SHOULDN'T be done! Why
> test something, and if it doesn't work try to get to the bottom of it -
> when
> you should NEVER put it in to practice anyway?
>
> Your wasting precious time that could be spent reading about
> tuning/backup/recovery/new features etc.
>
> Give up :)
>
> Mark
>
> alter user system identified by *********
>
> -----Original Message-----
> Gholam Hussain
> Sent: Monday, October 22, 2001 12:41
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Joe,
> I am doing that on a test DB .Some guys were able to drop SYSTEM user
> without any probem ...But I am facing some problem while droping it ..
>
>
> Regards ..
>
>
>
> > -----Original Message-----
> > From: Joe Testa [SMTP:teci_at_the-testas.net]
> > Sent: Monday, October 22, 2001 2:15 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Droping System User
> >
> > sure dont drop system user.
> >
> > joe
> > Ahmed Gholam Hussain wrote:
> > >
> > > 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)
> >
> > --
> > Joe Testa
> > Performing Remote DBA Services, need some backup DBA support?
> > For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> > ask :)
> > IM: n8xcthome or joen8xct
> > --
> > Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> > --
> > Author: Joe Testa
> > INET: teci_at_the-testas.net
> >
> > 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).
> --
> 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).
>
> --
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).
> --
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com
>
> 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).
>

-- 
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).