更改TEMP_TABLESPACE

vean0803i

tempfile 'd:\oradata\oradata\vijay\temp01_01.dbf' size 50


How to change the default temporary tablespace
SQL> create temporary tablespace temp01
  2  tempfile 'd:\oradata\oradata\vijay\temp01_01.dbf' size 50
  3  extent management local uniform size 10m;
已建立表格空間.
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
NAME
------------------------------
RMAN_TS
RECAT
TEMP01
已選取 14 個資料列.
SQL> alter tablespace temp offline;
alter tablespace temp offline
*
ERROR 在行 1:
ORA-03217: TEMPORARY TABLESPACE 的更改的選項無效

you cannot offline the temporary tablespace ^^"

SQL> drop tablespace temp;
drop tablespace temp
*
ERROR 在行 1:
ORA-12906: 無法刪除預設的暫時表格空間

you cannot delete the default temporary tablespace~

SQL> alter database default temporary tablespace temp01;
已更改資料庫.
SQL> drop tablespace temp;
已刪除表格空間.
SQL>