Scripts to Build Data Dictionary Views in Oracle

Scripts to Build Data Dictionary Views in Oracle

Script used to build the data dictionary view when you create the database manually. Then connect with sysdba user and run the script to create the data dictionary view.

Following are the script present in RDBMS folder of Oracle home location:

catalog.sql
Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms. Grant PUBLIC access to the synonyms.

catproc.sql
Runs all scripts required for or used with PL/SQL.

utlrp.sql
Recompiles all invalid objects its including packages, procedures, function and types.

Run the following script in this sequence:

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql

Connect to your Oracle Database instance as SYSTEM user:

pupbld.sql
Required for SQL*Plus. Enables SQL*Plus to disable commands by user.

Run the following script:

@?/sqlplus/admin/pupbld.sql

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.