1.相关查询:
select name from v$tempfile;
select tablespace_name,file_name from dba_temp_files;
2.创建临时表空间组:
2.1:新建2个表空间
create temporary tablespace temp1 tempfile '+DATA' size 400M tablespace group group1;
create temporary tablespace temp2 tempfile '+DATA' size 400M tablespace group group2;
2.2:统一组名
alter tablespace temp1 tablespace group GROUP2
2.3设置默认表空间:
alter database ‘DB_NAME’ default temporary tablespace GROUP2;
3. drop老的表空间临时文件
alter database tempfile '+DATA/orcl/tempfile/temp.286.830789045' drop including datafiles;
select * from dba_tablespace_groups;
select * from database_properties where property_name='DEFAULT_TEMP_TABLESPACE';
查询