Download
http://oracle-help.com/backup-and-recovery/recovery-recover-loss-temporary-tablespace/
Recover from a loss of a temporary tablespace
Share