Question - What is SYSTEM tablespace and when is it created?
Answer -
Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.