When an Oracle database is created, the SYSTEM tablespace is automatically created first. This tablespace contains the data dictionary and essential database metadata. The SYSTEM tablespace is always present and required for database operation, while other tablespaces like temporary tablespaces are created separately or as needed.