不超过5行命令解决 EXP-00056: ORA-25153: Temporary Tablespace is Empty
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
5指定默认的临时表空间
?
?
SQL>alter database default temporary tablespace temp;
ORA-12907: 表空间 TEMP 已经是默认的临时表空间
?
转自:http://hi.baidu.com/xuecj/blog/item/d91b474ead058b0eb3de05d7.html
