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