§ó§ï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;
¤w«Ø¥ßªí®æªÅ¶¡.
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
NAME
------------------------------
RMAN_TS
RECAT
TEMP01
¤w¿ï¨ú 14 ­Ó¸ê®Æ¦C.
SQL> alter tablespace temp offline;
alter tablespace temp offline
*
ERROR ¦b¦æ 1:
ORA-03217: TEMPORARY TABLESPACE ªº§ó§ïªº¿ï¶µµL®Ä

you cannot offline the temporary tablespace ^^"

SQL> drop tablespace temp;
drop tablespace temp
*
ERROR ¦b¦æ 1:
ORA-12906: µLªk§R°£¹w³]ªº¼È®Éªí®æªÅ¶¡

you cannot delete the default temporary tablespace~

SQL> alter database default temporary tablespace temp01;
¤w§ó§ï¸ê®Æ®w.
SQL> drop tablespace temp;
¤w§R°£ªí®æªÅ¶¡.
SQL>