oracle10G新特性之临时表空间组的应用
oracle10G新特性之临时表空间组的应用
1、创建几个临时表空间
create temporary tablespace temp1 tempfile '/home/oracle/oradata/rac/temp01.dbf' size 1024m reuse autoextend off extent management local uniform size 10m;
create temporary tablespace temp2 tempfile '/home/oracle/oradata/rac/temp02.dbf' size 1024m reuse autoextend off extent management local uniform size 10m;
create temporary tablespace temp3 tempfile '/home/oracle/oradata/rac/temp03.dbf' size 1024m reuse autoextend off extent management local uniform size 10m;
2、创建临时表空间组tempgrp
alter tablespace temp1 tablespace group tempgrp;
alter tablespace temp2 tablespace group tempgrp;
alter tablespace temp3 tablespace group tempgrp;
3、改变数据库默认表空间为表空间组
alter database default temporary tablespace tempgrp;
4、删除表空间组，必须首先删除组中的成员
alter tablespace temp1 tablespce group '';
alter tablespace temp2 tablespce group '';
alter tablespace temp3 tablespce group '';
5、将表空间组赋给用户
create user passion identified by passion default tablespace users temporary tablespace tempgrp;
6、显示临时表空间组中的成员，用视图DBA_TABLESPACE_GROUPS
select group_name,tablespace_name from dba_tablespace_groups;
