recovering from loss of a Temporary Tablespace

1.add another tempfile to the damaged temporary tablespace
2.take the damaged tempfile offline
3. Drop the damaged file
e.g
--alter tablespace temp_ts3 add temfile '' size 100M;
--alter tablespace tempfile '' offline;
--alter tablespace tempfile '' drop;

or work at the tablespace level
1. Create a new temporary tablespace
2. Switch users to the new temporary tablespace via ALTER DATABASE command
3. Drop the damaged tablespace
--alter tablespace temp_ts3 add temfile '' size 100M;
--alter tablespace tempfile '' offline;
--alter tablespace tempfile '' drop;