重建临时表空间

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

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博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134898/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134898/