Problem solve Get help with specific problems with your technologies, process and projects.

Can I create an Oracle Catalog Database with the Enterprise Console?

Want to create an Oracle Catalog Database with the Enterprise Console? Learn whether this is the best method with this tip from Oracle expert Brian Peasland.

I have an Oracle Database 10g. How do I create the Catalog Database through the Enterprise Console?
The Data Dictionary is created when one issues the CREATE DATABASE command. If you used the Database Configuration Assistant (DBCA) to create the database for you, it issued this command. After the CREATE DATABASE command, one normally runs the $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/rdbms/admin/catproc.sql scripts as the SYS user. The DBCA runs these for you automatically. These scripts set up Data Dictionary Views and Dynamic Performance Views. So this is probably already done for you.
This was last published in October 2009

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.