Re: Is this a CAREER-ENDING mistake ? Accidently ran catalog.sql
Date: Wed, 6 Aug 2008 19:24:27 -0700 (PDT)
On Aug 6, 9:33 pm, Chuck Whealton <chuck_wheal..._at_yahoo.com> wrote:
> On Aug 6, 8:54 pm, Richard <RSL..._at_gmail.com> wrote:
> > Platform 9i on solaris.
> > EXP(ort) was not functioning correctly so I ran catexp.sql as sys.
> > Still had some minor problem, at this point I ran CATALOG.sql because
> > some notes seem to suggest CATALOG.sql calls catexp.sql so why not run
> > the whole thing. Only to find it is a NO-NO against an existing db.
> > When I ran it it errors out with tons of display so I ctrl-C out of it
> > and check what catalog.sql does and got the shattering news that it
> > rebuilds the data dictionary, ok if you are building new db not
> > existing one.
> > I can still connect to the db but can't do much else. Says invalid pl/
> > sql packages when doing simple select * from dba_users, I was afraid
> > to even look at the output. Please help !
> Richard, did you backup the database first?
> Charles R. Whealton
> Charles Whealton @ pleasedontspam.com
There's no backup except there's an exp ...owner=sys, can that be used to restore ? As I understand all system packages are owned by sys, so the export of sys will restore it, I hope ? Received on Wed Aug 06 2008 - 21:24:27 CDT