When any database is created in the Oracle database system, a SYSTEM tablespace is automatically generated. The Data dictionary tables for the entire database are present in The SYSTEM tablespace. It is important that the SYSTEM tablespace remains online always as it contains the data dictionary that must be available to Oracle.
