问题： ORA-25153: Temporary Tablespace is Empty

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
USERS                          ONLINE
XDB                            ONLINE

TABLESPACE_NAME                STATUS
------------------------------ ---------
LICHENG_TEMP                   ONLINE
LICHENG                        ONLINE

13 rows selected.

temp tablespace在线

SQL> select tablespace_name,file_name from dba_temp_files;

no rows selected

就会发现，dba_temp_files 原来如此。

SQL> alter tablespace temp add tempfile '/u01/oradata/mydata/temp01.dbf' size 50M;

Tablespace altered.

SQL> select FILE_NAME,TABLESPACE_NAME,STATUS from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                STATUS
------------------------------ ---------
/u01/oradata/mydata/temp01.dbf
TEMP                           AVAILABLE

详细内容请参考http://www.itpub.net/thread-1229956-1-1.html