Temp Group생성 및 제거

--기존 템프 그룹에 포함
ALTER TABLESPACE TEMP TABLESPACE GROUP TEMP_TS_GROUP;

--새 템프 생성
CREATE TEMPORARY TABLESPACE TEMP2  TEMPFILE
   '/dev/vg_ora4/rdbf_ora4_10_01' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_02' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_03' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_04' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_05' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_06' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_07' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_08' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_09' SIZE 9999M AUTOEXTEND OFF,
   '/dev/vg_ora4/rdbf_ora4_10_10' SIZE 9999M AUTOEXTEND OFF
TABLESPACE GROUP TEMP_TS_GROUP;

--유저 템프 변경
ALTER USER migtohn TEMPORARY TABLESPACE temp_ts_group;
ALTER USER migtojb TEMPORARY TABLESPACE temp_ts_group;

------------------------------------------------------------------------
--삭제 법 그룹에서 제거
ALTER TABLESPACE temp2 TABLESPACE GROUP '';

--기존 템프로 다시 변경
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

ALTER TABLESPACE TEMP TABLESPACE GROUP '';

--기존 유저 템프 변경
ALTER USER migtohn TEMPORARY TABLESPACE temp;
ALTER USER migtojb TEMPORARY TABLESPACE temp;

--새로 추가 한 템프 삭제
DROP TABLESPACE TEMP2 ;

--템프 그룹 설정 확인 할수 있는 뷰
SELECT * FROM dba_tablespace_groups;