iWiz ShareBase

IT Specialist À±ÅÂÇöÀÇ iWiz ShareBase´Â IT»Ó ¾Æ´Ï¶ó °¢Á¾ Àâ´ÙÇÑ Áö½ÄµéÀ» ÇÔ²² ³ª´©´Â Áö½Ä°øÀ¯ Ä¿¹Â´ÏƼÀÔ´Ï´Ù.

iWiz,ShareBase,À±ÅÂÇö,Java,JSP,EJB,IT,Á¤º¸±â¼ú,À¥ÇÁ·Î±×·¡¹Ö,PHP,ASP,DBMS,MySQL,¼­¹ö,³×Æ®¿öÅ©,server,network,WAS,À¥¾ÖÇø®ÄÉÀ̼Ç,ºí·Î±×,blog,À¥¼­¹ö,DB,¿À¶óŬ,oracle,mysql,JRun,À¥·ÎÁ÷,ÅèĹ,tomcat,¾ÆÆÄÄ¡,ÀÚµ¿Â÷,EF½î³ªÅ¸,·Î¶Ç 6/45

°¶·¯¸® Pixelgrapher.com | ·Î¶Ç 6/45 ¹øÈ£»ý¼º ¹× Åë°è µ¥ÀÌÅÍ | Àüü±â»çº¸±â | Àüü±Û #1 | Àüü±Û #2 | Àüü±Û #3 | Àüü±Û #4 | Àüü±Û #5 | Àüü±Û #6 | Àüü±Û #7 | Àüü±Û #8 | Àüü±Û #9 | Àüü±Û #10 |
HOME iWiz
ShareBase
Remember 0523 & 0818
Áö½ÄÀº ³ª´­¼ö·Ï Ä¿Áý´Ï´Ù - iWiz's ShareBase
µ¥ÀÌÅͺ£À̽º µ¥ÀÌÅͺ£À̽º(DBMS)¿¡ °ü·ÃµÈ °¢Á¾ ÀÚ·áµéÀÔ´Ï´Ù.


  ¹ÚÁã(2004-05-03 15:19:07, Hit : 8965, Vote : 44

Default Temporary Tablespace ¼öÁ¤


1. Temporary Tablespace

    - Temporary Tablespace´Â Sort OperationÀ» À§ÇØ »ç¿ëµÇ´Â °ø°£À¸·Î, Àӽà µ¥ÀÌŸ¸¦ ÀúÀåÇϱâ À§ÇØ System

      Tablespace¸¦ »ç¿ëÇÏ´Â °ÍÀ» ¹æÁöÇÑ´Ù.

    - Permanent ObjectÀÇ ¼º°ÝÀ» °¡Áø µ¥ÀÌŸ´Â ÀúÀåÇÒ ¼ö ¾ø´Ù.

 

2. Default Temporary Tablespace ÀÇ º¯°æ

    1) Temporary Tablespace »ý¼º

        SQL>CREATE TEMPORARY TABLESPACE ASEAN_TEMP_TBS

                TEMPFILE '/data5/oracle_ts/asean3/asean_temp.dbf' SIZE 1024M

                EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M

        Tablespace created.

         * UNIFORM SIZE´Â SORT_AREA_SIZEÀÇ MultipleÀÌ µÇ°Ô SIZE¸¦ ¼³Á¤ÇØ ÁÖ¾î¾ß Sort Performance¸¦ ÃÖÀûÈ­

            ÇÒ ¼ö ÀÖ´Ù.

    

    2) Default Temporary TablespaceÀÇ º¯°æ

        SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE ASEAN_TEMP_TBS;

        Database altered. 

 

    3) ±âÁ¸ÀÇ Temporary Tablespace »èÁ¦

        SQL> DROP TABLESPACE TEMP;

        Tablespace dropped.

 

    4) OS»ó¿¡¼­ TempÆÄÀÏ »èÁ¦

        $ rm temp01.dbf

* iWiz´Ô¿¡ ÀÇÇؼ­ °Ô½Ã¹° À̵¿µÇ¾ú½À´Ï´Ù (2010-02-03 17:06)



22   ¿À¶óŬ ¹«·á °ü¸® ÅøÀÌ À־ ¼Ò°³ ÇÕ´Ï´Ù. [1]  ±è±â¿µ 2007/04/28 8292 0
21   ¿Ü¿öµµ ¿Ü¿öµµ ±î¸Ô´Â ¿À¶óŬ ÇÔ¼ö (¹Ø¿¡²¨ ÆÛ°¡´Â ´ë½Å ¤¾) [1]  ÀÌÁØÈ£ 2004/07/15 11955 43
  Default Temporary Tablespace ¼öÁ¤  ¹ÚÁã 2004/05/03 8965 44
19   ¸®µÎ·Î±× ÆÄÀÏÀÇ drop / add / relocation ¹× rename  ¹ÚÁã 2004/04/22 7059 33
18   ¿À¶óŬ ±âº» ¸í·É¾î Á¤¸® [2]  iWiz 2004/04/07 9790 42
17   ¿À¶óŬÀÇ Undo Segment [3]  ¹ÚÁã 2004/04/06 9090 38
16   ER Diagram ÀÛ¼º ÇÁ·Î±×·¥ ERWin »ç¿ë ¹æ¹ý  iWiz 2004/04/04 13143 38
15   import À¯Æ¿¸®Æ¼ [3]  ¹ÚÁã 2004/04/01 6538 35
14   ¼¼¼Ç°ü¸®  ¹ÚÁã 2004/03/31 8165 31
13   LogMiner  ¹ÚÁã 2004/03/31 7341 39
12   ¿À¶óŬ¿¡¼­ÀÇ ¹é¾÷...  ¹ÚÁã 2004/03/30 6336 40
11   ¿À¶óŬÀÇ Constraint(Á¦¾àÁ¶°Ç)  ¹ÚÁã 2004/03/26 37575 38
10   Export À¯Æ¿¸®Æ¼ [1]  ¹ÚÁã 2004/03/23 5693 35
9   ºñ±³ / ³í¸® ¿¬»êÀÚ ¹× ¿¬»ê ¿ì¼± ¼øÀ§  ¹ÚÁã 2004/03/22 9336 41
8   NULLÀ̶õ?? [2]  ¹ÚÁã 2004/03/22 7993 32

1 [2]
 

Copyright 1999-2024 Zeroboard / skin by zero
iWiz ShareBase, ¨ÏCopyleft by iWiz.  For more information contact .
º» À¥»çÀÌÆ®¿¡ °Ô½ÃµÈ À̸ÞÀÏ ÁÖ¼Ò°¡ ÀüÀÚ¿ìÆí ¼öÁý ÇÁ·Î±×·¥À̳ª ±× ¹ÛÀÇ ±â¼úÀû ÀåÄ¡¸¦ ÀÌ¿ëÇÏ¿© ¹«´ÜÀ¸·Î ¼öÁýµÇ´Â °ÍÀ» °ÅºÎÇϸç, À̸¦ À§¹Ý½Ã¿¡´Â Á¤º¸Åë½Å¸Á¹ý¿¡ ÀÇÇØ Çü»çó¹úµÊÀ» À¯³äÇϽñ⠹ٶø´Ï´Ù. [°Ô½ÃÀÏ 2004. 1. 31]