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: Walt Weaver <wweaver_at_rightnowtech.com>
Date: Thu, 25 May 2000 07:15:25 -0600
Message-Id: <10508.106662@fatcity.com>


I suppose you could. But, having done this myself once, it's probably faster just to recreate the darn thing.

--Walt Weaver
  Bozeman, Montana, USA

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ruth Gramolini
Sent: Thursday, May 25, 2000 7: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
Received on Thu May 25 2000 - 08:15:25 CDT

Original text of this message

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