installation question

[tang]

Hi there,

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.

[Shestakov]

Yes u can. But before had better create cold backup.

[Jr]

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.

Jr.

[Shestakov]

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.

[tang]

Thanks a lot!