oracle 更改默认临时表空间

create temporary tablespace temp2 tempfile ‘/opt/oracle/oradata/orcl/temp2.dbf’ size 20480m autoextend on next 50m maxsize 30720m extent management local;

设置默认表空间

alter database default temporary tablespace temp2;

须重启数据库，才能删除之前的表空间，不然删除命名会夯住

shutdown immediate;

startup

删除之前的表空间

DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;