Add or alter Temp file in Oracle database

Add tempfile to temp tablespace

alter tablespace TEMP1 add tempfile 'E:\oradata\temp02.dbf' size 1G autoextend on next 200M;

Resize temp file in Oracle database

alter database tempfile 'E:\oradata\temp02.dbf' resize 2G;

Drop temp file in Oracle database

ALTER DATABASE TEMPFILE 'E:\oradata\temp02.dbf' DROP INCLUDING DATAFILES;