Temp Files

1、来自动态性能视图v$tempfile，临时文件信息

SQL> select file#,name from v$tempfile;

     FILE# NAME
---------- ------------------------------------------------------------
         1 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\TEMP01.DBF

2、添加临时文件

alter tablespace temp

add tempfile 'f:\app\user\oradata\kelongdb\temp01.dbf' size 200M;