select TABLESPACE_NAME, BYTES_USED/1024/1024/1024 as GB_USED , BYTES_FREE/1024/1024/1024 GB_FREE from V$TEMP_SPACE_HEADER;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u20/oradata/CCIRPAT/DATAFILES/temp_SID_02.dbf' size 10G reuse autoextend on next 10M maxsize 20g;
ALTER DATABASE TEMPFILE '/u20/oradata/CCIRPAT/DATAFILES/temp_SID_01.dbf' DROP INCLUDING DATAFILES;