ORA-25153 Temporary Tablespace is Empty

ORA-25153:	Temporary Tablespace is Empty
Cause:	An attempt was made to use space in a temporary tablespace with no files.
Action:	Add files to the tablespace using ADD TEMPFILE command.

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TEMP

SQL> select file_name from dba_temp_files where tablespace_name='TEMP';

no rows selected

SQL> ALTER TABLESPACE TEMP add tempfile '/u02/app/oracle/oradata/tetris11/temp01.dbf' size 100M reuse;

Tablespace altered.

SQL> select file_name from dba_temp_files where tablespace_name='TEMP';

/u02/app/oracle/oradata/tetris11/temp01.dbf