临时表空间temporary tablespace相关操作

---如果已经作了setnewname操作，则会提示已作，会提示略过；
run{
set newname for tempfile  '/oracle/app/oracle/oradata/zxy/newtemp01_pos.dbf' to '/oracle/newpos_temp01.dbf';
set newname for tempfile  '/oracle/temp02.dbf' to '/oracle/newpos_temp02.dbf';
restore database;
switch tempfile all;
}

---数据库open删除临时表空间某个临时文件
SQL> alter database tempfile '/oracle/newpos_temp02.dbf' drop including datafiles;

Database altered.

---rename file可以在mount状态作，但临时文件先要物理复制过去才可以，不然报错
SQL> alter database rename file '/oracle/app/oracle/oradata/zxy/newtemp01.dbf' to '/oracle/newtemp01_pos.dbf';
alter database rename file '/oracle/app/oracle/oradata/zxy/newtemp01.dbf' to '/oracle/newtemp01_pos.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
"/oracle/app/oracle/oradata/zxy/newtemp01.dbf"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-764887/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-764887/