
Starter Database Contents
5-24 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS
SYSTEM system01.dbf
The data dictionary
. This includes
definitions of tables, views, and stored
procedures needed by the Oracle database.
Note: The database maintains information
in this area automatically
. The SYSTEM
tablespace is present in all Oracle
databases.
TEMP temp01.dbf Temporary tables and/or indexes created
during the processing of your SQL
statement
Note: You might need to expand this
tablespace if you are executing a SQL
statement that involves a lot of sorting,
such as ANALYZE COMPUTE STATISTICS
on a very large table, or the constructs
GROUP BY, ORDER BY, or DISTINCT.
TOOLS tools01.dbf The Installer creates this data file when the
user wants to install any third-party or
Oracle tools/products.
USERS users01.dbf As you generate and enter data into tables,
you fill this space with your data.
See Also: Oracle9i Database Concepts and Oracle9i Database
Administrator’s Guide for more information on tablespaces and data
files.
Table 5–2 Tablespaces and Data Files (Cont.)
Tablespace Data File Contains...
Commenti su questo manuale