When the database is created in Oracle database system, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database.
In Oracle, the SYSTEM tablespace is a special tablespace that is automatically created when a new database is created. It is used to store the data dictionary, which contains metadata about the database, such as information about tables, indexes, and other database objects.
The SYSTEM tablespace should be used exclusively for storing the Oracle database’s data dictionary tables and any other Oracle-managed objects. It is a critical component of the Oracle database and should be treated with care. The SYSTEM tablespace should not be used to store user data or application data, as it is essential for the functioning of the Oracle database.
When a new Oracle database is created, the SYSTEM tablespace is automatically created as part of the database creation process. The data dictionary tables and other essential structures are stored in this tablespace, making it a fundamental component of the Oracle database architecture.