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.