Adding a Datafile to Temp Tablespace

Query to see Current Temp Datafiles State

select d.TABLESPACE_NAME, d.FILE_NAME, d.BYTES/1024/1024 SIZE_MB, d.AUTOEXTENSIBLE, d.MAXBYTES/1024/1024 MAXSIZE_MB, d.INCREMENT_BY*(v.BLOCK_SIZE/1024)/1024 INCREMENT_BY_MB
from dba_temp_files d,
 v$tempfile v
where d.FILE_ID = v.FILE#
order by d.TABLESPACE_NAME, d.FILE_NAME;

Add Temp Datafile to Temp Tablespace

ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA' SIZE 20G AUTOEXTEND ON NEXT 1G MAXSIZE 32g;

Hariprasath Rajaram