建立新的临时表空间,再设定系统默认临时表空间为新建空间;

SQL> create temporary tablespace tem tempfile 'D:oracleoradatabjmobiletem01.dbf' size 100m;

Tablespace created.

SQL> alter database default temporary tablespace tem;

Database altered.

检查用户临时表空间信息

SQL> select username,temporary_tablespace
2 from dba_users;

USERNAME TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYS TEM
SYSTEM TEM
RMAN TEM
DBSNMP TEM
PERFSTAT TEM
OUTLN TEM
WKSYS TEM
ORDPLUGINS TEM

......................

如果使用其他临时表空间,就使用alter user重新设定;

删除旧的临时表空间

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

ITPub博客

重建临时表空间

最新文章