Creating the Data Dictionary

Oracle creates the data dictionary automatically when you create a database. Thereafter, whenever the database is in operation, Oracle updates the data dictionary in response to every DDL statement.

The data dictionary base tables are the first objects created in any Oracle database. They are created in the SYSTEM tablespace and must remain there. The data dictionary base tables store information about all user-defined objects in the database.

Table 5-1 lists required scripts, which are run automatically when you create a database. They are described here because you might need to run them again when upgrading to a new release of Oracle. To run these scripts you must be connected to Oracle as the user SYS.

See Also: Your release notes and Oracle8i Migration to learn when it is necessary to run these scripts. Your operating system specific Oracle documentation for the exact names and locations of these scripts on your system. Oracle8i Administrator's Guide for more information about scripts with names starting with DBMS.

Table 5-1 Creating the Data Dictionary Scripts

Script Name	Needed For	Description
CATALOG.SQL	All databases	Creates the data dictionary and public synonyms for many of its views Grants PUBLIC access to the synonyms
CATPROC.SQL	All databases	Runs all scripts required for or used with PL/SQL