Problem:Recovering from a lost tempfile

Impact: It can affect certain operations which use data in the temp files.
Solution:Restart the database. The database starts and if the original disk directory location is available, Oracle recreates all missing tempfiles.
If the temp datafiles are nopt recovered then:
recreate the temp files as shown:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE Maxsize unlimited;