Link to home
Start Free TrialLog in
Avatar of dbaseek

asked on


what is catalog.sql?

please mention its role in database creation?
Avatar of dbaseek


please reply asap........................
Avatar of anand_2000v
catalog.sql is the script which has to be executed first as soon as database has been created using the "create database" command.
it will create the base dictionary objects. If you will notice, just after db creation you will not have objects like
tab,dual, dba_objects and so on.
in addition to these catalog will also create the Standard package which will contain a number of required db pl/sql procedures and functions.
Avatar of dbaseek


             Catalog.sql is a common script or not? i mean it is same for everydatabases....
how can i execute catalog.sql?
Can you give me a link or copy of catalog.sql?

I would appreciate that
Catalog.sql is supplied in $ORACLE_HOME/rdbms/admin.  Catalog.sql is a driver that calls many other scripts from the same directory.  I think it is very version specific since often patch instructions will tell you to rerun it (I assume because the patch changed something in it).

Our instance create procedure runs several supplied scripts:
@$ORACLE_HOME/rdbms/admin/catexp -- viewd for export
@$ORACLE_HOME/rdbms/admin/catproc -- PL/SQL stuff
@$ORACLE_HOME/rdbms/admin/catblock -- Views for seeing lock holders and waiters, may be old
@$ORACLE_HOME/rdbms/admin/dbmspool -- pool statistics
@$ORACLE_HOME/rdbms/admin/catrep -- needed to use symetric replication
@$ORACLE_HOME/rdbms/admin/xaview -- needed for interfacing with external transaction managers
@$ORACLE_HOME/rdbms/admin/catsnmp.sql -- creates views used by OEM
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql -- provides public synonyms for a lot of SYS.DBA views

We always create DBs from scripts, if you use a GUI like installer or DBCAthen a lot of this is run for you.
Avatar of dbaseek


Catalog.sql is supplied in $ORACLE_HOME/rdbms/admin.

how can I execute this?
Avatar of NorCal2612

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaseek


thank you
You're welcome. Good luck. :)