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. 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_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 [ < <<A
href="">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: <A
href="">
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: <A
href="">
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: <A
href="">
http://www.orafaq.com--Author: Ahmed
Gholam Hussain INET: ahussain_at_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_at_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_at_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_at_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_at_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_at_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).
Received on Mon Oct 22 2001 - 11:10:48 CDT
