Oracle Database Editor - Tablespace Tab

The following describes the options for the Tablespace tab in the Oracle Database Editor dialog:

System Tablespace
A list box filtered with the databasename.SYSTEM tablespace and is NULL. Click the button to open the Tablespace Editor. This tablespace is created upon database creation. This tablespace can only be deleted upon database deletion. If you rename the database, then this tablespace is also renamed. It cannot be forward-engineered. If this tablespace is locally managed, it impacts two other options in this tab, Default Temporary Tablespace and Default Permanent Tablespace; they cannot be dictionary managed.
Default Temporary Tablespace
A list box filtered with Temporary tablespaces only if they exist. Click the button to browse for the tablespace.
Undo Tablespace
A list box filtered with Undo tablespaces only if they exist. Click the button to browse for the tablespace.
Sysaux Tablespace
This option is available for Oracle 10g only. Sysaux Tablespace is filtered with the databasename.SYSAUX tablespace and is NULL. Click the button to browse for the tablespace. This tablespace is created upon database creation. This tablespace can only be deleted upon database deletion. If you rename the database, then this tablespace is also renamed. It cannot be forward-engineered.
Default Permanent Tablespace
This option is available for Oracle 10g only. The Default Permanent Tablespace option is a list box filtered with Permanent tablespaces only if they exist. Click the button to browse for the tablespace.

Note: For Forward Engineering DDL logic, the following applies regarding each option in this tab:

System Tablespace
Generates the Extent Management Local or the Datafile clause, or both (applies for Oracle 9i and 10g)
Default Temporary Tablespace
Generates the default_temp_tablespace clauses (applies for Oracle 9i and 10g)
Undo Tablespace
Generates the undo_tablespace clauses (applies for Oracle 9i and 10g)
SYSAUX Tablespace
Generates the SYSAUX clause (Oracle 10g only)
Default Permanent Tablespace
Generates the default_tablespace clauses (Oracle 10g only)