创建临时表空间组

创建临时表空间组

Create temporary tablespace TMP_XI

Tempfile ‘/u01/app/oracle/oradata/VDEDU/temp_xl.dbf’

Size 10m autoextend on;

SQL> alter tablespace TEMP_XI tablespace group temp_grp;

SQL> select * from dba_tablespace_groups;

GROUP_NAME        TABLESPACE_NAME

------------------------------ ------------------------------

TEMP_GRP        TEMP_XI

SQL> create temporary tablespace TEMP_XII

  2  tempfile '/u01/app/oracle/oradata/VDEDU/temp_xii.dbf'

  3  size 10m autoextend on tablespace group temp_grp;

SQL> select * from dba_tablespace_groups;

GROUP_NAME        TABLESPACE_NAME

------------------------------ ------------------------------

TEMP_GRP        TEMP_XI

TEMP_GRP        TEMP_XII