RE: catproc run as system

I believe you can. I think I ran into exactly the same thing with a twist. I had to upgrade, ran it, and found all these duplicates in system. Maybe they were there all along. Then I had to go through and pull all the dups, and because of synonyms and all, think I had to rerun it under sys, the newer one, again.

I never lost any data though, whew...

Maks.

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ruth
> Gramolini
> 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
Received on Thu May 25 2000 - 09:06:47 CDT