Reclaim temporary table space ORA-03297 problem Solving

Today found temporary table space reached 15G, but the utilization rate is only 2% less, recycling

sql> ALTER DATABASE tempfile ' D:\ORACLE\ORADATA\YNRMDB\TEMP01.DBF ' resize 2048M;

ALTER DATABASE tempfile ' D:\ORACLE\ORADATA\YNRMDB\TEMP01.DBF ' resize 2048M

*

ERROR is on line 1th:

ORA-03297: file contains data that is used outside of the RESIZE value of the request

It looks like the usual method is more troublesome.

SQL>alter database tempfile 'd:\oracle\oradata\ynrmdb\temp01.dbf' drop ;
Database altered.
SQL>alter tablespace temp add tempfile
　　2'd:\oracle\oradata\ynrmdb\temp01.dbf'
　　3 size 2048M reuse autoextend on next 100M;
Tablespace altered.
SQL> select d.file_name, d.file_id, d.tablespace_name, d.bytes from dba_temp_files d;

file_name file_id Tablespace_name BYTES

------------------------------------ ---------- --------------- ----------

D:\ORACLE\ORADATA\YNRMDB\TEMP01. DBF 1 TEMP 2147483648