ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§ó§ïTEMP_TABLESPACE

§ó§ïTEMP_TABLESPACE

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>
vean0803i

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD