About Tablespaces and Data Files
For both single-instance and cluster database environments, Oracle Database is divided into smaller logical areas of space known as tablespaces.
Each tablespace corresponds to one or more data files on the shared storage. The following table shows the tablespace names used by an Oracle RAC database and the types of data they contain.
Table 6-2 Tablespace Names Used with Oracle Real Application Clusters Databases
| Tablespace Name | Contents |
|---|---|
|
|
An auxiliary system tablespace that contains the |
|
|
Consists of the data dictionary, including definitions of tables, views, and stored procedures needed by the database. Oracle Database automatically maintains information in this tablespace. |
|
|
Contains temporary tables and indexes created during SQL statement processing. You may need to expand this tablespace if you run a SQL statement that involves significant sorting, such as |
|
|
Contains undo tablespaces for each instance that DBCA creates for automatic undo management. |
|
|
Consists of application data. As you create and enter data into tables, Oracle Database fills this space with your data. |
You cannot alter these tablespace names when using the preconfigured database configuration option from OUI. However, you can change the names of the tablespaces if you use the advanced database creation method.
As mentioned, each tablespace has one or more data files on shared file systems. The data file names created by the preconfigured database configuration options vary by storage type such as Oracle ASM, or a cluster file system.