Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterviewList the default tablespaces of Oracle.
course 16

List the default tablespaces of Oracle.

The default tablespaces of Oracle are as follows:-

  1. 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.
  2. The USERS tablespace – It is used for ad-hoc users.
  3. The UNDOTBS1 tablespace – Is used for holding the undo data.
  4. The TEMP tablespace – It is the temporary tablespace that is used for storing intermediate results of sorting, hashing, and large object processing operations.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...