不超过5行命令解决 EXP-00056: ORA-25153: Temporary Tablespace is Empty

不超过5行命令解决 EXP-00056: ORA-25153: Temporary Tablespace is Empty2008年12月10日 星期三 17:11EXP-00056: ORACLE error 25153 encountered
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