[小e笔记]之错误案例——ORA-25153错误

错误描述如下：

SQL> select dbms_metadata.get_ddl('TABLE','TEST') from dual;

ERROR:

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "SYS.DBMS_LOB", line 664

ORA-06512: at "SYS.DBMS_METADATA", line 3825

ORA-06512: at "SYS.DBMS_METADATA", line 5678

ORA-06512: at line 1

no rows selected

解决方法：  --很简单解决的

(1)故障定位

SQL> select name from v$tempfile;    --发现临时文件丢失

no rows selected

也会从警告日志中可以看出确实临时文