SYSTEM tablespace
Used for core functionality.
Stores the data dictionary ( belong to sys schema).
Oracle create system tablespace automatically when the database is created.
you cannot rename or drop the SYSTEM tablespace.
SYSAUX tablespace
The SYSAUX tablespace is an auxiliary tablespace to the SYSTEM tablespace.
It reduces the load on the SYSTEM tablespace.
Oracle create it automatically when the database is created
you cannot rename or drop the SYSAUX tablespace.
TEMP tablespace
are used to manage space for database sort and joining operations and for storing
global temporary tables.
Other SQL operations that might require disk sorting are: CREATE INDEX, ANALYZE,
SELECT DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS,…
UNDO tablespace
is used to roll back, or undo, changes to the database.
• Roll back transactions when a ROLLBACK statement is issued
• Recover the database
• Provide read consistency
USERS tablespace
stores users objects and data
Every database should have a tablespace for permanent user data that is assigned
to users. Otherwise, user objects will be created in the SYSTEM tablespace, which
is not good practice.
In the preconfigured database, USERS is designated as the default tablespace for
all new users.
Note: all these tablespaces exits in the container database and also the pluggable databases .
