ORA-25153: Temporary Tablespace is Empty

错误：

ERROR at line 1:

ORA-25153: Temporary Tablespace is Empty

解决办法：

看了一下DBA_TABLESPACES，TEMP的status还online

SQL> SELECT TABLESPACE_NAME,STATUS FROM DBA_TABLESPACES;

TABLESPACE_NAME STATUS

------------------------------ ---------

SYSTEM           ONLINE

UNDOTBS1        ONLINE

TEMP              ONLINE

CWMLITE          ONLINE

DRSYS             ONLINE

EXAMPLE           ONLINE

INDX               ONLINE

ODM               ONLINE

TOOLS             ONLINE

SQL> select tablespace_name, file_name from dba_temp_files;

no rows selected
我们会遇到两种情况，一种是OS level的physical datafile不见了，一种是logical tempfile不见了， 不过我这次遇到的是第二种情况。
 

SQL>          alter tablespace temp add tempfile '/cio/oracle/mc/temp01.dbf'

Tablespace altered.

SQL>     select FILE_NAME,TABLESPACE_NAME,STATUS from dba_temp_files;

FILE_NAME TABLESPACE_NAME STATUS

----------------------------------- ------------------------------ ---------

/cio/oracle/mc/temp01.dbf TEMP AVAILABLE

Ok, 问题解决！！！