Add datafile to temporary tablespace

Add datafile to temporary tablespace:

ALTER TABLESPACE TEMP1 ADD TEMPFILE '<datafile.dbf>' SIZE 2G AUTOEXTEND ON NEXT 10M MAXSIZE 2G;

Remove datafile from temporary tablespace:

alter tablespace TEMP1 drop tempfile '<datafile.dbf>';