Google News
logo
Oracle - Interview Questions
List the default tablespaces of Oracle.
The default tablespaces of Oracle are as follows :
 
The SYSTEM and SYSAUX tablespaces : These store system-generated objects such as data dictionary tables in them. One should not store any object in these tablespaces.

The USERS tablespace : It is used for ad-hoc users.

The UNDOTBS1 tablespace : Is used for holding the undo data.

The TEMP tablespace : It is the temporary tablespace that is used for storing intermediate results of sorting, hashing, and large object processing operations.
 
Advertisement