ORA-25153: Temporary Tablespace is Empty

Cause :- You have no temp file in your temporary tablespace.

Solution:- Check your temporary tablespace and add temp file.

SQL> FLASHBACK TABLE A1 TO TIMESTAMP (TO_DATE('20-JUL-14 11:54:36','DD-MON-YY HH:MI:SS'));
FLASHBACK TABLE A1 TO TIMESTAMP (TO_DATE('20-JUL-14 11:54:36','DD-MON-YY HH:MI:SS'))
                *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty

SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE '%DEFAULT_TEMP_TABLESPACE%';

PROPERTY_VALUE
--------------------------------------------------------------------------------
TEMP

SQL> SELECT NAME FROM V$TEMPFILE;

no rows selected

SQL> ALTER TABLESPACE TEMP
  2  ADD TEMPFILE 'D:\APP\ORADATA\ORCL\TEMP02.DBF' SIZE 10M AUTOEXTEND ON;

Tablespace altered.

SQL> SELECT NAME FROM V$TEMPFILE;

NAME
--------------------------------------------------------------------------------
D:\APP\ORADATA\ORCL\TEMP02.DBF

SQL> FLASHBACK TABLE A1 TO TIMESTAMP (TO_DATE('20-JUL-14 11:54:36','DD-MON-YY HH:MI:SS'));

Flashback complete.

SQL>