I have a simple question. Do I have to run the files such as catalog.sql and catproc.sql as a sys user after the installation of Oracle9i? Thanks a lot.
Yes u can. But before had better create cold backup.
Catalog scripts are run for a DB creation / fixing.
Cat Scripts are automatically run when DB created using DBCA ( Database Configuration Assistant ).
A Manual DB creation also involves running of Cat scripts manually.
catalog.sql create set of data dictionary views (like dba_tables ...).
each view creation command in catalog.sql use syntax:
CREATE or REPLACE VIEW ...
then if u execute this script u don't change any rows in real tables of oracle
dictionary, except tables than keep view definition (like sys.source$, sys.obj$ ..), but
this rows oracle will change thru sql commands (CREATE VIEW) execution not directly using DELETE / INSERT commands.
conclusion: u can execute this script in any time not only as part of installation process.
Click Here to Expand Forum to Full Width