Resizing Temporary Tablespace

 SELECT tablespace_name, file_name, bytes
    FROM dba_temp_files WHERE tablespace_name = 'TEMP';

ALTER DATABASE TEMPFILE '/u02/oracle/data/temp02.dbf' RESIZE 18M;