oracle临时表空间组

select * from dba_tablespace_groups;
select * from dba_temp_files;
select * from v$tablespace;
select * from dba_tablespaces
----------------创建临时表空间
create temporary tablespace APP_TEMPORARY_1 tempfile '/u02/app/oracle/oradata/xxx/APP_TEMPORARY_1_01.dbf' 
size 500m 
autoextend on 
next 100m
extent management local;

create temporary tablespace APP_TEMPORARY_2 tempfile '/u02/app/oracle/oradata/xxx/APP_TEMPORARY_2_01.dbf'
size 500m 
autoextend on 
next 100m
extent management local;

create temporary tablespace APP_TEMPORARY_3 tempfile '/u02/app/oracle/oradata/xxx/APP_TEMPORARY_3_01.dbf'
size 500m 
autoextend on 
next 100m
extent management local;

create temporary tablespace APP_TEMPORARY_4 tempfile '/u02/app/oracle/oradata/xxx/APP_TEMPORARY_4_01.dbf'
size 500m 
autoextend on 
next 100m
extent management local;


----------------创建临时表空间,并创建临时表空间

create temporary tablespace APP_TEMPORARY_4 tempfile '/u02/app/oracle/oradata/xxx/APP_TEMPORARY_4_01.dbf'
size 500m 
autoextend on 
next 100m
extent management local
tablespace group APP_TEMPORARY_GROUP;

----------------创建临时表空间组

alter tablespace APP_TEMPORARY_1 tablespace group APP_TEMPORARY_GROUP;
alter tablespace APP_TEMPORARY_2 tablespace group APP_TEMPORARY_GROUP;
alter tablespace APP_TEMPORARY_3 tablespace group APP_TEMPORARY_GROUP;
alter tablespace APP_TEMPORARY_4 tablespace group APP_TEMPORARY_GROUP;

----------------指定用户的临时表空间组
select * from dba_users;

alter user temporary tablespace APP_TEMPORARY_GROUP;
alter user ngessync temporary tablespace APP_TEMPORARY_GROUP;
alter user recovery temporary tablespace APP_TEMPORARY_GROUP;
alter user sync temporary tablespace APP_TEMPORARY_GROUP;
alter user risk temporary tablespace APP_TEMPORARY_GROUP;
alter user report temporary tablespace APP_TEMPORARY_GROUP;
alter user operation temporary tablespace APP_TEMPORARY_GROUP;
alter user settlement temporary tablespace APP_TEMPORARY_GROUP;
alter user historysettlement temporary tablespace APP_TEMPORARY_GROUP;
alter user fbtransfer temporary tablespace APP_TEMPORARY_GROUP;
alter user fbtransferhistory temporary tablespace APP_TEMPORARY_GROUP;
alter user fbexchange temporary tablespace APP_TEMPORARY_GROUP;
alter user fbexchangehistory temporary tablespace APP_TEMPORARY_GROUP;


----------------将临时表空间从临时表空间组移出
alter tablespace APP_TEMPORARY_4 tablespace group '';
alter tablespace APP_TEMPORARY_3 tablespace group '';
alter tablespace APP_TEMPORARY_2 tablespace group '';
alter tablespace APP_TEMPORARY_1 tablespace group '';

----------------删除组中所有的临时表空间后，组会自动删除
drop tablespace APP_TEMPORARY_1 including contents and datafiles;
drop tablespace APP_TEMPORARY_2 including contents and datafiles;
drop tablespace APP_TEMPORARY_3 including contents and datafiles;
drop tablespace APP_TEMPORARY_4 including contents and datafiles;

----------------指定用户的临时表空间组
select * from dba_users;

alter user ngessync temporary tablespace TEMP;
alter user recovery temporary tablespace TEMP;
alter user sync temporary tablespace TEMP;
alter user risk temporary tablespace TEMP;
alter user report temporary tablespace TEMP;
alter user operation temporary tablespace TEMP;
alter user settlement temporary tablespace TEMP;
alter user historysettlement temporary tablespace TEMP;
alter user fbtransfer temporary tablespace TEMP;
alter user fbtransferhistory temporary tablespace TEMP;
alter user fbexchange temporary tablespace TEMP;
alter user fbexchangehistory temporary tablespace TEMP;