Temp File add

SQL> select name,bytes/1024/1024 from v$tempfile;

NAME                                                                               BYTES/1024/1024
---------------------------------------------------------------------------------------------------
/oracle1/VIS1211/db/apps_st/data/temp1_01.dbf              16000
/oracle1/VIS1211/db/apps_st/data/temp2_01.dbf                  0

SQL> desc dba_tablespace_groups;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NAME                                NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)

SQL> select *from dba_tablespace_groups;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEMP                           TEMP2
TEMP                           TEMP1

sql> select a.name , b.name from V$tablespace a, V$tempfile b where a.TS#=b.TS#;

SQL> alter tablespace TEMP2 add tempfile '/oracle1/VIS1211/db/apps_st/data/temp3_01.dbf' size 100m;

Tablespace altered.

SQL>