更改系统的默认临时表空间:
SQL> alter database default temporary tablespace temp1; |
所有用户的默认临时表空间都将切换为新的临时表空间:
SQL> select username,temporary_tablespace,default_ from dba_users; USERNAME TEMPORARY_TABLESPACE ------------------------------ ------------------------------ MGMT_VIEW TEMP1 SYS TEMP1 SYSTEM TEMP1 DBSNMP TEMP1 SYSMAN TEMP1 SCOTT TEMP1 OUTLN TEMP1 MDSYS TEMP1 ORDSYS TEMP1 EXFSYS TEMP1 DMSYS TEMP1 USERNAME TEMPORARY_TABLESPACE ------------------------------------------------------------ WMSYS TEMP1 CTXSYS TEMP1 ANONYMOUS TEMP1 XDB TEMP1 ORDPLUGINS TEMP1 SI_INFORMTN_SCHEMA TEMP1 OLAPSYS TEMP1 ORACLE_OCM TEMP1 TSMSYS TEMP1 BI TEMP1 PM TEMP1 |
更改某一用户的临时表空间:
SQL> alter user scott temporary tablespace temp; |