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 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:

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

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

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

Run the following script in this sequence:


Connect to your Oracle Database instance as SYSTEM user:

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

Run the following script:


Leave a Reply

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

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