Avatar of dbaseek
 asked on


what is catalog.sql?

please mention its role in database creation?
Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon

please reply asap........................

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.

             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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

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.

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

how can I execute this?

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

thank you
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.

You're welcome. Good luck. :)