1查看表空间状态

SQL> select tablespace_name,status from dba_tablespaces

TABLESPACE_NAME??????????????? STATUS
------------------------------ ---------
SYSTEM???????????????????????? ONLINE
SYSAUX???????????????????????? ONLINE
TEMP?????????????????????????? ONLINE
USERS????????????????????????? ONLINE
EXAMPLE??????????????????????? ONLINE
UNDO_TBS1????????????????????? ONLINE
UNDOTBS3?????????????????????? ONLINE

7 rows selected

?

2查询系统临时表空间

SQL>????select tablespace_name,file_name from dba_temp_files;

TABLESPACE_NAME??????????????? FILE_NAME
------------------------------ ---------------------------------------------------

3增加并修改临时表空间

SQL>???alter tablespace temp add tempfile 'D:\oracle\product\10.2.0\oradata\orcl\TEMP02.DBF' size 200M;

4再次查询系统临时表空间

SQL>??select FILE_NAME,TABLESPACE_NAME,STATUS from dba_temp_files;

FILE_NAME???????????????????????????????????????????? TABLESPACE_NAME??????????????? STATUS
--------------------------------------------?
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP02.DBF????????? TEMP???????? AILABLE