To add temp /data file in oracle

To add  temp/ data file
 in oracle

ALTER TABLESPACE TEMP ADD TEMPFILE '/home/oracle/oracle/product/10.2.0/db_1/oradata/test/temp02.dbf' size 1g;

in linux platform

ALTER TABLESPACE TEMP ADD TEMPFILE 
'C:\Oracle\oradata\TEMP3\Temp02.dbf' size 50M reuse autoextend on next 1M maxsize 500M; in windows platform


In 11g we can shrink the temp tablespace.


To add the datafile:

alter tablespace la add datafile '
/home/oracle/oracle/product/10.2.0/db_1/oradata/test/la4.dbf' size
512m;