Oracle数据库表空间6--临时表空间创建修改

SQL> column name format a50;SQL> select file#,status,name from v$tempfile;     FILE# STATUS  NAME---------- ------- ------------------------------------------------         1 ONLINE  D:\APP\JGWANG\ORADATA\ORCL\TEMP01.DBF         2 ONLINE  D:\APP\SQLTEST\SELF\TEM.DBFSQL> alter tablespace temspace  2  add tempfile 'D:\app\SQLTest\Self\tem02.dbf'  3  size 5M;表空间已更改。SQL> select file#,status,name from v$tempfile;     FILE# STATUS  NAME---------- ------- ----------------------------------------------         1 ONLINE  D:\APP\JGWANG\ORADATA\ORCL\TEMP01.DBF         2 ONLINE  D:\APP\SQLTEST\SELF\TEM.DBF         3 ONLINE  D:\APP\SQLTEST\SELF\TEM02.DBFSQL>