Oracle10g临时表空间组

Oracle10g临时表空间组

Oracle10g新特性之临时表空间组

(2007-05-21 11:43:45)

转载▼

分类：Oracle10g

<wbr><span style="font-family:宋体">Oracle10g新特性之临时表空间组</span></wbr>

<wbr><wbr><wbr>临时表空间组，这是Oracle10g的新特性，即在oracle中可以存在一个或多个临时表空间组，组中包括多个临时表空间，但一个组至少包含一个临时表空间。临时表空间组无法显式创建，当第一个临时表空间创建时分配给一个组名时自动创建，而当组内所有临时表空间被移除时该临时表空间组也将自动删除。<br> 可以将不同的临时表空间组分配给不同的用户，大家互不干扰。<br> SQL&gt; conn sys/sys@ora10g as sysdba;<br> 已连接。<br> SQL&gt; select * from dba_tablespace_groups;<br> 未选定行<br> SQL&gt; select tablespace_name from dba_tablespaces;<br> TABLESPACE_NAME<br> ------------------------------<br> SYSTEM<br> UNDOTBS1<br> SYSAUX<br> TEMP<br> USERS<br> --创建一个临时表空间，并分配一个临时表空间组，将自动地创建该组<br> SQL&gt; create temporary tablespace temp1<br><wbr> 2<wbr> tempfile'D:\oracle\oradata\ora10g\temp1.dbf' size 10m<br><wbr> 3<wbr> tablespace groupgroup1;<br> 表空间已创建。<br> SQL&gt; select * from dba_tablespace_groups;<br> GROUP_NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TABLESPACE_NAME<br> ------------------------------ ------------------------------<br> GROUP1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP1<br> SQL&gt; create temporary tablespace temp2<br><wbr> 2<wbr> tempfile'D:\oracle\oradata\ora10g\temp2.dbf' size 10m<br><wbr> 3<wbr> tablespace groupgroup2;<br> 表空间已创建。<br> SQL&gt; select * from dba_tablespace_groups;<br> GROUP_NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TABLESPACE_NAME<br> ------------------------------ ------------------------------<br> GROUP1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP1<br> GROUP2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP2<br> --也可以把一个存在的临时表空间分配到一个临时表空间组中<br> SQL&gt; alter tablespace temp tablespace group group2;<br> 表空间已更改。<br> SQL&gt; select * from dba_tablespace_groups;<br> GROUP_NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TABLESPACE_NAME<br> ------------------------------ ------------------------------<br> GROUP2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP<br> GROUP1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP1<br> GROUP2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TEMP2<br> --可以在不同组中移动<br> SQL&gt; alter tablespace temp tablespace group group1;<br> 表空间已更改。<br> SQL&gt; select * from dba_tablespace_groups;<br> GROUP_NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TABLESPACE_NAME<br> ------------------------------ ------------------------------<br> GROUP1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>