操作步骤：
1. 先建立一个中转临时表空间
2. 删除原临时表空间
3. 然后再重建回来
操作命令：
建立一个中转临时表空间
create temporary tablespace temp2
tempfile ‘/u01/oradata/orcl/temp02.dbf’ size 512M
reuse autoextend on next 100M maxsize 2048M;
alter database default temporary tablespace temp2;
drop tablespace temp including contents and datafiles;
重新建立一个新的临时表空间
create temporary tablespace temp
tempfile ‘/u01/oradata/orcl/temp01.dbf’ size 512M
reuse autoextend on next 100M maxsize 1024M;
alter database default temporary tablespace temp;
drop tablespace temp2 including contents and datafiles;