How to Drop and Add a Tempfile

Drop a Tempfile:

ALTER DATABASE TEMPFILE '/u02/oradata/temp03.dbf' DROP INCLUDING DATAFILES;


Add a Tempfile:

ALTER TABLESPACE TEMP ADD TEMPFILE '/u04/oradata/temp01.dbf'
SIZE 2000M REUSE AUTOEXTEND ON NEXT 1024M MAXSIZE 32767M;