Database Reference
In-Depth Information
Some Tablespaces in the Oracle Database
Every Oracle database should have following tablespaces.
SYSAUX
This is an auxiliary tablespace to the SYSTEM tablespace. It is a
mandatory tablespace and cannot be dropped or renamed.
Components that use this tablespace as their default tablespace
are Enterprise Manager Repository, Automatic Workload
Repository, Oracle Streams, Oracle Text, XML DB, Recovery
Catalog, Scheduler, Statspack etc.
SYSTEM
This tablespace is used by Oracle to manage the database. It's
always created at the time of creation of database. It contains
data dictionary and other tables, views containing database
administrative information e.g. dynamic performance base tables
etc.
UNDOTBS1
This tablespace is used by Oracle Instance to store undo
information. Every database must have this tablespace and can
be created at the time of creation of database.
TEMP
This tablespace holds the data for temporary period of time e.g.
during processing sort operations. Every database should have
TEMP tablespace and is assigned to database users. In a
preconfigured Oracle database structure, TEMP tablespace is
created as default temporary tablespace. It means that in case
you do not assign any temporary tablespace to database users,
Oracle Instance assign this as temporary tablespace.
EXAMPLE
This tablespace contains the sample schemas. These sample
schemas contain tables and other objects used as examples in
Oracle documentation and other educational material.
Search WWH ::
Custom Search