Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: catproc run as system

RE: catproc run as system

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Thu, 25 May 2000 11:24:05 -0400
Message-Id: <10508.106696@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFC65D.441F7C10
Content-Type: text/plain;

        charset="iso-8859-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).

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

------_=_NextPart_001_01BFC65D.441F7C10
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: catproc run as system</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>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). </FONT></P>
<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ruth Gramolini [<A =
HREF=3D"mailto:rgramolini_at_tax.state.vt.us">mailto:rgramolini_at_tax.state.v= t.us</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, May 25, 2000 9:12 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: catproc run as system</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Rachel,</FONT>
<BR><FONT SIZE=3D2>I am just wondering.&nbsp; Couldn't you just run it =
as sys and then drop the</FONT>
<BR><FONT SIZE=3D2>stuff in the system schema?&nbsp; Far be in from me =
to disagree with a goddess</FONT>
<BR><FONT SIZE=3D2>&lt;g&gt; and I have met you.&nbsp; But perhaps you =
halo's glow obscured the real you.</FONT>
<BR><FONT SIZE=3D2>Not!</FONT>
<BR><FONT SIZE=3D2>Ruth</FONT>
<BR><FONT SIZE=3D2>----- Original Message -----</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, May 24, 2000 9:54 PM</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&gt; I did that once... and the only way to fix it =
was to recreate the</FONT>
<BR><FONT SIZE=3D2>database.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; sorry</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Rachel</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;From: &quot;S. Anthony Sequeira&quot; =
&lt;Sequeira_at_lineone.net&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Reply-To: ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;To: Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Subject: catproc run as system</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Date: Wed, 24 May 2000 14:04:07 =
-0800</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Hi,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; One of our trainee =
DBAs has managed to run catproc as system!</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Fortunately it is not a mission critical =
instance, though a production</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;one.&nbsp; Surprisingly it is still =
running!</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; Is there any easy =
way to 'uninstall' catproc from the system schema,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;without going the exp/recreate/imp =
route?</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; Regards.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Tony</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;--</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;S. A. Sequeira</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;One of these days I will</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;cut you into little pieces</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Opinions expressed herein are my own and =
do</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;not necessarily represent those of my =
employer</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;--</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Author: S. Anthony Sequeira</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp; INET: =
Sequeira_at_lineone.net</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;Fat City Network Services&nbsp;&nbsp;&nbsp; =
-- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt; =
&gt;--------------------------------------------------------------------=
</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;To REMOVE yourself from this mailing list, =
send an E-Mail message</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;to: ListGuru_at_fatcity.com (note EXACT =
spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;the message BODY, include a line =
containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;(or the name of mailing list you want to be =
removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;also send the HELP command for other =
information (like subscribing).</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; =
________________________________________________________________________=
</FONT>
<BR><FONT SIZE=3D2>&gt; Get Your Private, Free E-mail from MSN Hotmail =
at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; Author: Rachel Carmichael</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: carmichr_at_hotmail.com</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt; =
--------------------------------------------------------------------</FO= NT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an E-Mail message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information (like subscribing).</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ruth Gramolini</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: rgramolini_at_tax.state.vt.us</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
Received on Thu May 25 2000 - 10:24:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US