oracle10G新特性之临时表空间组的应用[@more@]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;
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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20444553/viewspace-1006116/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20444553/viewspace-1006116/