Each Oracle database contains a SYSTEM tablespace and a SYSAUX tablespace. They are
automatically created when the database is created. The system default is to create a smallfile
tablespace. You can also create bigfile tablespaces, which enable the Oracle database to
manage ultralarge files (up to 8 exabytes).