How to move tempfile to another location online!

alter tablespace temp add tempfile '/u01/app/oracle/oradata/KNK/temp02.dbf' size 1024m autoextend on;

alter tablespace temp drop tempfile '/u01/app/oracle/oradata/KNK/temp01.dbf';


Check tempfiles from dba_temp_files.


If you still see the dropped tempfile, check whether any sessions running, which are probably use TEMP tablespace.


After you kill the relevant sessions (if you need to), check dba_temp_files again.


Check if file still exists in OS. If yes then drop it!