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