Re: catproc run as system

Thanks Joe.....

Ruth: you can't drop the objects, I tried... got all screwed up with the synonyms on the v$ tables and couldn't clear them

Alex: no one is holding me to a higher standard than anyone else here.

Rachel

>From: "Joseph S. Testa" <teci_at_oracle-dba.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: catproc run as system
>Date: Thu, 25 May 2000 10:30:47 -0800
>
>Alex, u evidently DONT know Rachel, she's fun and takes it all in
>stride.
>
>joe
>
>
>Alex Hillman wrote:
>
> >
> >
> > Doesn't matter if Rachel answer right or wrong maybe we can end this
> > goddess stuff already? Writing couple of books does not mean that the
> > person should know or remember everything. Why should we keep her or
> > any author to higher standards than any of us and we all have right to
> > not know something or be wrong. And also I don't think that she
> > appreciate using this termin this very much (as clear from her posts).
> >
> > Alex Hillman
> >
> > -----Original Message-----
> > From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> > Sent: Thursday, May 25, 2000 9:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: catproc run as system
> >
> > Rachel,
> > I am just wondering. Couldn't you just run it as sys and then drop
> > the
> > stuff in the system schema? Far be in from me to disagree with a
> > goddess
> > <g> and I have met you. But perhaps you halo's glow obscured the real
> > you.
> > Not!
> > Ruth
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, May 24, 2000 9:54 PM
> >
> > > I did that once... and the only way to fix it was to recreate the
> > database.
> > >
> > > sorry
> > >
> > > Rachel
> > >
> > >
> > > >From: "S. Anthony Sequeira" <Sequeira_at_lineone.net>
> > > >Reply-To: ORACLE-L_at_fatcity.com
> > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > >Subject: catproc run as system
> > > >Date: Wed, 24 May 2000 14:04:07 -0800
> > > >
> > > >Hi,
> > > >
> > > > One of our trainee DBAs has managed to run catproc as system!
> > > >Fortunately it is not a mission critical instance, though a
> > production
> > > >one. Surprisingly it is still running!
> > > >
> > > > Is there any easy way to 'uninstall' catproc from the system
> > schema,
> > > >without going the exp/recreate/imp route?
> > > >
> > > > Regards.
> > > >
> > > >Tony
> > > >--
> > > >S. A. Sequeira
> > > >
> > > >One of these days I will
> > > >cut you into little pieces
> > > >
> > > >Opinions expressed herein are my own and do
> > > >not necessarily represent those of my employer
> > > >
> > > >--
> > > >Author: S. Anthony Sequeira
> > > > INET: Sequeira_at_lineone.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).
> > >
> > >
> > ________________________________________________________________________
> >
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> > >
> > > --
> > > Author: Rachel Carmichael
> > > INET: carmichr_at_hotmail.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).
> >
> > >
> >
> > --
> > Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > 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).