Add/drop tempfile - oracle database script

-- Add tempfile to temp tablespace:  alter tablespace TEMP1 add tempfile '/u01/aodba/tempfile/temp02.dbf' size 1G autoextend on next 200M;  -- Resize temp file:  alter database tempfile '/u01/aodba/tempfile/temp02.dbf' resize 2G;  -- Drop tempfile:  ALTER DATABASE TEMPFILE '/u01/aodba/tempfile/temp02.dbf' DROP INCLUDING DATAFILES;