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: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 25 May 2000 07:59:14 -0400
Message-Id: <10508.106650@fatcity.com>


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 -----
From: Rachel Carmichael <carmichr_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 24, 2000 9:54 PM
Subject: Re: catproc run as system

> 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).
Received on Thu May 25 2000 - 06:59:14 CDT

Original text of this message

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