10.1.0中做AWR分析时碰到，如下：

Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_90_96.html.  To use this name,

press to continue, otherwise enter an alternative.

输入 report_name 的值:  c:\awr.html

Using the report name c:\awr.html

select output from table(dbms_workload_repository.awr_report_html( :dbid,

                         *

第 1 行出现错误:

ORA-25153: Temporary Tablespace is Empty

Report written to c:\awr.html

处理过程：

SQL> col tablespace_name for a20

SQL> col status for a20

SQL> select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME      STATUS

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

SYSTEM               ONLINE

UNDOTBS1             ONLINE

SYSAUX               ONLINE

TEMP                 ONLINE

USERS                ONLINE

MYUSER               ONLINE

PART01               READ ONLY

PART02               READ ONLY

PART03               READ ONLY

IDX_MYUSER           ONLINE

LUNAR                ONLINE

已选择11行。

SQL> col file_name for a30

SQL> select tablespace_name,file_name from dba_temp_files;

未选定行

SQL> alter tablespace temp add tempfile 'D:\oradata\demo\temp01.dbf';

表空间已更改。

SQL> select tablespace_name,file_name from dba_temp_files;

TABLESPACE_NAME      FILE_NAME

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

TEMP                 D:\ORADATA\DEMO\TEMP01.DBF

后续就没问题了，只是AWR没出来东西。