临时表空间组创建及删除

一、临时表空间组创建

1、

SQL> alter tablespace temp tablespace group temgrp;

Tablespace altered.

2、

SQL> create temporary tablespace temp2 tempfile '/u01/app/oracle/temp02.dbf' size 10M tablespace group temgrp;

Tablespace created.

3、

SQL> alter database default temporary tablespace temgrp;

Database altered.

二、临时表空间组删除

1、

SQL> alter tablespace temp tablespace group '';

Tablespace altered.

2、

SQL> alter database default temporary tablespace temp;

Database altered.

3、

SQL> drop tablespace temp2 including contents and datafiles;

Tablespace dropped.