Re: catproc run as system

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Thu, 25 May 2000 13:07:08 -0400
Message-Id: <10508.106734@fatcity.com>

--------------44606E8388C426CA6D619840
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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

--------------44606E8388C426CA6D619840
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
Alex, u evidently DONT know Rachel, she's fun and takes it all in stride.

<p>joe
<br>&nbsp;
<p>Alex Hillman wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font size=-1>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).

<p><font size=-1>Alex Hillman</font>
<p><font size=-1>-----Original Message-----</font>
<br><font size=-1>From: Ruth Gramolini [<a href="mailto:rgramolini_at_tax.state.vt.us">mailto:rgramolini_at_tax.state.vt.us</a>]</font>
<br><font size=-1>Sent: Thursday, May 25, 2000 9:12 AM</font>
<br><font size=-1>To: Multiple recipients of list ORACLE-L</font>
<br><font size=-1>Subject: Re: catproc run as system</font>
<p><font size=-1>Rachel,</font>
<br><font size=-1>I am just wondering.&nbsp; 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.

<br><font size=-1>Not!</font>
<br><font size=-1>Ruth</font>
<br><font size=-1>----- Original Message -----</font>
<br><font size=-1>To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com></font>
<br><font size=-1>Sent: Wednesday, May 24, 2000 9:54 PM</font>
<p><font size=-1>> I did that once... and the only way to fix it was to

recreate the

<br><font size=-1>database.</font>
<br><font size=-1>></font>
<br><font size=-1>> sorry</font>
<br><font size=-1>></font>
<br><font size=-1>> Rachel</font>
<br><font size=-1>></font>
<br><font size=-1>></font>
<br><font size=-1>> >From: "S. Anthony Sequeira" &lt;Sequeira_at_lineone.net></font>
<br><font size=-1>> >Reply-To: ORACLE-L_at_fatcity.com</font>
<br><font size=-1>> >To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com></font>
<br><font size=-1>> >Subject: catproc run as system</font>
<br><font size=-1>> >Date: Wed, 24 May 2000 14:04:07 -0800</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >Hi,</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >&nbsp;&nbsp;&nbsp;&nbsp; One of our trainee DBAs has

managed to run catproc as system! > >Fortunately it is not a mission critical instance, though a production

<br><font size=-1>> >one.&nbsp; Surprisingly it is still running!</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >&nbsp;&nbsp;&nbsp;&nbsp; Is there any easy way to

'uninstall' catproc from the system schema,

<br><font size=-1>> >without going the exp/recreate/imp route?</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >&nbsp;&nbsp;&nbsp;&nbsp; Regards.</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >Tony</font>
<br><font size=-1>> >--</font>
<br><font size=-1>> >S. A. Sequeira</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >One of these days I will</font>
<br><font size=-1>> >cut you into little pieces</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >Opinions expressed herein are my own and do</font>
<br><font size=-1>> >not necessarily represent those of my employer</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >--</font>
<br><font size=-1>> >Author: S. Anthony Sequeira</font>
<br><font size=-1>> >&nbsp;&nbsp; INET: Sequeira_at_lineone.net</font>
<br><font size=-1>> ></font>
<br><font size=-1>> >Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858)

538-5051  FAX: (858) 538-5051 > >San Diego, California        -- Public Internet access / Mailing Lists

<br><font size=-1>> >--------------------------------------------------------------------</font>
<br><font size=-1>> >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).

<br><font size=-1>></font>
<br><font size=-1>> ________________________________________________________________________</font>
<br><font size=-1>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com</font>
<br><font size=-1>></font>
<br><font size=-1>> --</font>
<br><font size=-1>> Author: Rachel Carmichael</font>
<br><font size=-1>>&nbsp;&nbsp; INET: carmichr_at_hotmail.com</font>
<br><font size=-1>></font>
<br><font size=-1>> Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858)

538-5051  FAX: (858) 538-5051 > San Diego, California        -- Public Internet access / Mailing Lists

<br><font size=-1>> --------------------------------------------------------------------</font>

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

<br><font size=-1>></font>
<p><font size=-1>--</font>
<br><font size=-1>Author: Ruth Gramolini</font>
<br><font size=-1>&nbsp; INET: rgramolini_at_tax.state.vt.us</font>
<p><font size=-1>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br><font size=-1>--------------------------------------------------------------------</font>

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 Received on Thu May 25 2000 - 12:07:08 CDT