Create temporary tablespace group in oracle and create in oracle
After oracle11g, you can create a temporary tablespace group. A temporary tablespace group can contain one or more temporary tablespaces.
A temporary tablespace group must consist of at least one temporary tablespace and has no explicit maximum number limit.
If you delete all the members of a temporary tablespace group, the group is also automatically deleted.
The name of the temporary tablespace cannot be the same as that of the temporary tablespace group.
When you assign a temporary tablespace to a user, you can use the name of the temporary tablespace group to replace the actual temporary tablespace name. When you assign a default temporary tablespace to the database, you can also use the name of the temporary tablespace group.
Temporary tablespace Group
Create a temporary tablespace Group
Temporary tablespace groups do not need to be created. You only need,
Use the teblespace group statement to specify a group.
View the temporary tablespace group information.
Data Dictionary dba_tablespace_grops
Move temporary tablespace
Use the alter tablespace statement
SQL> create temporary tablespace tempgroup
2 tempfile 'f: \ oracledata \ tempgroup01.dbf' size 5 m
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 5 m
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;
The tablespace has been changed.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------------------------------------
GROUP02 TEMPGROUP
GROUP02 TEMPGROUP02