Re: Help: Data Dictionary Recovery

From: <afilonov_at_pro-ns.net>
Date: Tue, 16 Mar 1999 02:31:56 GMT
Message-ID: <7ckfqs$2f3$1@nnrp1.dejanews.com>

It's strange. Did you run catalog.sql under sys? If not, run it again, it has to restore all views (make a backup first...). Also check if grants and synonyms on those views are created when it runs. If you need access to DBA views, run catdbsyn.sql (it can be DBA-SYN.sql in 7.1), it will create synonyms and grants for other users than sys.

In article <OhUoWJub#GA.342_at_nih2naaa.prod2.compuserve.com>, "PC" <private_comm_at_hotmail.com> wrote:
> Help,
>
> I mistakenly ran the catalog.sql scripts on a 7.1 database and now all data
> dictionary views are gone. I can still see it under sys but that is it. I
> can't exported the database because the dictionary is dead. Any help on how
> to recover dict will be greatly appreciated.
>
> Many Thanks.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 20:31:56 CST