Oracle Audio Technologies ORACLE9I B10508-01 User Manual

Page 100

Advertising
background image

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

Advertising