| |
In Oracle 11g later, the user can create a temporary table space group, a group of temporary table space can contain one or more temporary table spaces.
Temporary tablespace group must consist of at least a temporary tablespaces, and no clear maximum limit on the number.
If you remove all the members of a temporary table space group, the group is also automatically deleted.
The name of the temporary table space is not the same as the name of the temporary tablespace group.
Assigned to the user in a temporary table space, temporary table space can use the name instead of the actual group of temporary table space name; when allocated to the database default temporary table space, you can also use the name of the temporary table space group.
Temporary table space group
Create a temporary table space group
Temporary tablespace group does not require specially created, just you need to create a temporary table space,
Use teblespace group statement assigned to a group.
View the temporary table space group information.
Data Dictionary dba_tablespace_grops
Mobile temporary table space
Use alter tablespace statement
SQL> create temporary tablespace tempgroup
2 tempfile 'f: \ oracledata \ tempgroup01.dbf' size 5m
3 tablespace group group01;
Table space 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;
Table space 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 |
|
|
|