Oracle8 Server Reference Release 8.0 A54645_01 |
|
This chapter describes the SQL scripts that are required for optimal operation of the Oracle Server. The SQL scripts are described in the following sections:
Note: Check the header of each SQL script for more detailed information and examples.
The data dictionary is automatically created when a database is created. 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 and must remain in the SYSTEM tablespace. The data dictionary base tables are present to store information about all user-defined objects in the database.
Table 6-1 lists the scripts that are required for the Oracle Server with the indicated options. The appropriate scripts for your Oracle Server options 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 Oracle8. Your release notes and Oracle8 Server Migration indicate when this is necessary. Run these scripts connected to the Oracle Server as the user SYS.
The exact names and locations of these scripts are operating system dependent. See your operating system specific Oracle documentation for the names and locations on your system.
For more information about scripts with names starting with DBMS, see the Oracle8 Server Administrator's Guide.
.Oracle supplies other scripts with the Oracle Server that create additional structures you can use in managing your database and creating database applications. These scripts are listed in Table 6-2.
The exact names and locations of these scripts are operating system dependent. See your operating system-specific Oracle documentation for the names and locations on your system.
The scripts in Table 6-3 are used to remove dictionary information for certain optional services or components.
For more information, see Oracle8 Server Migration.
The scripts in Table 6-4 are useful when migrating to another version or release.
For more information, see Oracle8 Server Migration.