SQL> select * from database_properties where property_name like 'DEFAULT%';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- ---------------- --------------------------------------
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESP USERS Name of default permanent tablespace
ACE
DEFAULT_EDITION ORA$BASE Name of the database default edition
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
SQL> alter database default temporary tablespace test_temp;
Database altered.
SQL> select * from database_properties where property_name like 'DEFAULT%';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- ---------------- --------------------------------------
DEFAULT_TEMP_TABLESPACE TEST_TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESP USERS Name of default permanent tablespace
ACE
DEFAULT_EDITION ORA$BASE Name of the database default edition
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type