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:[EMAIL PROTECTED]] > 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 > > > >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] > > 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:[EMAIL PROTECTED]] > > > > 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:[EMAIL PROTECTED]] > > > > Sent: Friday, October 05, 2001 12:30 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Droping System User > > > > > > > > > -----Original Message----- > > > > > From: [EMAIL PROTECTED] [ < < > <mailto:[EMAIL PROTECTED]>>>] > > > > > > > > > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
