oracle之临时表空间组(二)
CE_GROUPS;
GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GROUP01 TEMP
TEMP_GROUP01 TEMP02
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_GROUP01;
Database altered.
SQL>
SQL> select * from database_properties where rownum<5;
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ -------------------------------------------------- ----------------------------------------------------------------------
DICT.BASE 2 dictionary base tables version #
DEFAULT_TEMP_TABLESPACE TEMP_GROUP01 Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
DEFAULT_EDITION ORA$BASE Name of the database default edition
SQL>
6）把一个临时表空间移动到 其他临时表空间中；
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GROUP01 TEMP
TEMP_GROUP01 TEMP02
SQL> alter tablespace temp02 tablespace group temp_group02;
Tablespace altered.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GROUP01 TEMP
TEMP_GROUP02 TEMP02
SQL>