From JTESTA@longaberger.com Mon, 22 Oct 2001 09:10:48 -0700 From: "JOE TESTA" Date: Mon, 22 Oct 2001 09:10:48 -0700 Subject: RE: Droping System User Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@gmd.fujitsu.com 10/22/01 12:15PM >>>Um, I have to disagree, although I must admit I will not try it.  Itsa 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 AMTo: Multiple recipients of list ORACLE-LSo - why bother? Your having problems doing it - it SHOULDN'T be done! Whytest something, and if it doesn't work try to get to the bottom of it - whenyou should NEVER put it in to practice anyway?Your wasting precious time that could be spent reading abouttuning/backup/recovery/new features etc.Give up :)Markalter user system identified by *********-----Original Message-----Gholam HussainSent: Monday, October 22, 2001 12:41To: Multiple recipients of list ORACLE-LHi Joe,I am doing that on a test DB .Some guys were able to drop SYSTEM userwithout any probem ...But I am facing some problem while droping it ..Regards ..> -----Original Message-----> From:    Joe Testa [SMTP:teci@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@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@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@radisys.com [ < <mailto:Jared.Still@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@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@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@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@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@gisqatar.org.qaFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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@cool-tools.co.ukFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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@gmd.fujitsu.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).