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>
