When executing SQL query, sometimes you may get the following Oracle error:
ORA-25153: Temporary Tablespace is Empty
The cause for the ORA-25153 error is because attempt was made to use space in a temporary tablespace with no files (no datafiles defined).
To solve the problem, the solution is just by adding files (datafiles) to the TEMP tablespace by using ADD TEMPFILE command.
For more information go through below link