SQL> create temporary tablespace tempgroup 2 tempfile 'f:\oracledata\tempgroup01.dbf' size 5m 3 tablespace group group01;
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;
SQL> select * from dba_tablespace_groups; GROUP_NAME TABLESPACE_NAME ------------------------------ ------------------------------ GROUP01 TEMPGROUP GROUP02 TEMPGROUP02 SQL> alter tablespace tempgroup tablespace group group02;表空間已更改。
SQL> select * from dba_tablespace_groups; GROUP_NAME TABLESPACE_NAME ------------------------------ ------------------------------ GROUP02 TEMPGROUP GROUP02 TEMPGROUP02