After oracle11g, the user can create a temporary tablespace group that can contain one or more temporary table spaces in a temporary table space group.
A temporary table space group must consist of at least one temporary tablespace and no explicit maximum limit.
If you delete all members of a temporary tablespace group, the group is also automatically deleted.
The name of a temporary tablespace cannot be the same as the name of a temporary table space group.
When assigning a temporary tablespace to a user, you can use the name of the temporary table Space group instead of the actual temporary tablespace name, or you can use the name of the temporary tablespace group when assigning a default temporary tablespace to the database.
Temporary table space groups
To create a temporary table space group
Temporary tablespace groups do not need to be created specifically, only when you create a temporary table space.
Use the Teblespace group statement to assign a group to it.
View the staging Tablespace group information.
Data dictionary Dba_tablespace_grops
Move temporary table space
Using the ALTER TABLESPACE statement
sql> Create temporary tablespace tempgroup
2 tempfile ' f:\oracledata\tempgroup01.dbf ' size 5m
3 tablespace group GROUP01;
The tablespace has been created.
Sql> select * from Dba_tablespace_groups;
Group_name Tablespace_name
------------------------------ ------------------------------
GROUP01 Tempgroup
sql> Create temporary tablespace tempgroup02
2 tempfile ' f:\oracledata\tempgroup02.dbf ' size 5m
3 tablespace group GROUP02;
The tablespace has been created.
Sql> select * from Dba_tablespace_groups;
Group_name Tablespace_name
------------------------------ ------------------------------
GROUP01 Tempgroup
GROUP02 TEMPGROUP02
sql> alter tablespace tempgroup tablespace group group02;
Table space has changed.
Sql> select * from Dba_tablespace_groups;
Group_name Tablespace_name
------------------------------ ------------------------------
GROUP02 Tempgroup
GROUP02 TEMPGROUP02
Oracle creates a temporary tablespace group
