How to recover
data dictionary?
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.
Ans1:
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.
Ans2:
try connecting as system and running catdbsyn
it may be that just your synonyms have gone
--
Diane
Ans3:
Rebuild the views. If you have previous
exports you can extract
the DDL and rebuild the views from that.
Or export from another
7.1 instance and get the dictionary views
from that.
I have a script that can get DDL from an
export file.
URL:http://www.tc.umn.edu/~hause011/
the script is ugly_DDL
---------------------------------------------------------
Steven Hauser