想起前几天重建了控制文件，才导致tempfile丢失，重新把tempfile加进去就可以了

SYS>select * from v$tempfile;

no rows selected

SYS>alter tablespace temp2 add tempfile 'd:oracleoradatatestdbtemp01.dbf' reuse

Tablespace altered.