Oracle Audio Technologies ORACLE9I B10508-01 User Manual
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.
procedures needed by the Oracle database.
Note:
The database maintains information
in this area automatically
.
The SYSTEM
tablespace is present in all Oracle
databases.
databases.
TEMP
temp01.dbf
Temporary tables and/or indexes created
during the processing of your SQL
statement
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.
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.
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.
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.
files.
Table 5–2
Tablespaces and Data Files (Cont.)
Tablespace
Data File
Contains...