Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
what is catalog.sql?
please mention its role in database creation?
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
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:
catexp -- viewd for export
catproc -- PL/SQL stuff
catblock -- Views for seeing lock holders and waiters, may be old
dbmspool -- pool statistics
catrep -- needed to use symetric replication
xaview -- needed for interfacing with external transaction managers
l -- creates views used by OEM
ql -- 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?
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-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.
See how we're fighting big data
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
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
You're welcome. Good luck. :)
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent