Scripts to Build Data Dictionary Views in Oracle

Leave a reply

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 Privileges to 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

Leave a Reply

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

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com 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 )

Cancel

Connecting to %s

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