1. SQL> shutdown immediate
SQL> 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. SQL> alter database tempfile 'D:\oracle\product\10.2.0\oradata\cat\temp01.dbf' autoextend off;