Oracle 临时表空间

• [size=large; text-indent: 21pt;]临时表空间的作用[/size]

• [size=large;]重建临时表空间的操作步骤[/size]

[size=10.5000pt; font-family: '新宋体';]2) [/size][size=10.5000pt; font-family: '新宋体';]改变缺省临时表空间 为刚刚创建的新临时表空间temp1[/size]



[size=10.5000pt; font-family: '新宋体';]4) [/size][size=10.5000pt; font-family: '新宋体';]重新创建临时表空间[/size]



[size=10.5000pt; font-family: '新宋体';]6) [/size][size=10.5000pt; font-family: '新宋体';]删除中转用临时表空间TEMP1[/size]

[size=10.5000pt; font-family: '新宋体';]7) [/size][size=10.5000pt; font-family: '新宋体';]指定用户表空间为重建的临时表空间[/size]

[code="sql"]SQL>create temporary tablespace TEMP1 TEMPFILE 'D:\oracle\oradata\orcl\temp1.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
SQL>alter database default temporary tablespace TEMP1;
SQL>drop tablespace TEMP including contents and datafiles;
SQL>create temporary tablespace TEMP TEMPFILE 'D:\oracle\oradata\orcl\temp.dbf ' SIZE 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
SQL>alter database default temporary tablespace TEMP;
SQL>drop tablespace TEMP1 including contents and datafiles;
SQL>alter user username temporary tablespace TEMP; -- username为需要重新指定临时表空间的用户名