Temporary Tablespace : Group

SELECT * FROM database_properties
WHERE property_name like '%TABLESPACE';

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------ --------------------------------------
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace

Group Temporary Tablespaces

ALTER TABLESPACE temp TABLESPACE GROUP temp_ts_group;

SELECT * FROM dba_tablespace_groups;

ALTER USER scott TEMPORARY TABLESPACE temp_ts_group;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp_ts_group;


Remove from group

ALTER TABLESPACE temp2 TABLESPACE GROUP '';

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;