create temporary tablespace TEMP2 TEMPFILE '/oradata/temp02.dbf' SIZE 512M ;
alter database default temporary tablespace temp2;
drop tablespace temp including contents and datafiles;
create temporary tablespace TEMP TEMPFILE '/oradata/temp01.dbf' SIZE 10000M;
alter database default temporary tablespace temp;
drop tablespace temp2 including contents and datafiles;
alter user userxxxxx temporary tablespace temp; --这步应该是没有必要的 可以先查看看是否默认还temp