1,shutdown immediate
startup mount
2, SQL> alter database tempfile 'D:\oracle\product\10.2.0\oradata\cat\temp01.dbf' drop;
3, SQL> alter database open
4, SQL> alter tablespace temp add tempfile 'D:\oracle\product\10.2.0\oradata\cat\temp01.dbf' size 2048M reuse autoextend on next 100M;
5, alter database tempfile 'D:\oracle\product\10.2.0\oradata\cat\temp01.dbf' autoextend off;