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-03-23 13:56:26, Hit : 5924, Vote : 35

Export À¯Æ¿¸®Æ¼


1. °³¿ä

   export À¯Æ¿¸®Æ¼´Â ³í¸®Àû ¹é¾÷À» Á¦°øÇÏ´Â À¯Æ¿¸®Æ¼ ÀÔ´Ï´Ù. ³í¸®Àû ¹é¾÷À̶õ ¹°¸®ÀûÀÎ µ¥ÀÌŸ ÆÄÀÏÀ» ¹é¾÷ ¹Þ´Â ´Ù´Â °³³äÀÌ ¾Æ´Ï°í µ¥ÀÌŸº£À̽º °´Ã¼, ½ºÅ°¸¶ °´Ã¼, Å×ÀÌºí½ºÆäÀ̽ºµî¿¡ ´ëÇÑ ³í¸®ÀûÀÎ ¹é¾÷À» ÇÑ´Ù´Â ÀÇ¹Ì ÀÔ´Ï´Ù. µû¶ó¼­ ½Ç¼ö·Î Å×À̺íÀ» »èÁ¦Çϰųª, Å×À̺íÀÇ ³í¸®ÀûÀÎ ÈѼÕ, À߸øµÈ DML¹®¿¡ ´ëÇØ º¹±¸ÇÒ ¼ö°¡ ÀÖ½À´Ï´Ù.

 

2. export ¸ðµå

table ¸ðµå

user ¸ðµå

tablespace ¸ðµå

full database ¸ðµå

Å×À̺í Á¤ÀÇ

Å×À̺í Á¤ÀÇ

Å×À̺í Á¤ÀÇ

Å×À̺í Á¤ÀÇ

Å×ÀÌºí µ¥ÀÌŸ

Å×ÀÌºí µ¥ÀÌŸ

 

Å×ÀÌºí µ¥ÀÌŸ

¼ÒÀ¯ÀÚÀÇ Å×ÀÌºí ±ÇÇÑ ºÎ¿©

¼ÒÀ¯ÀÚÀÇ ±ÇÇÑ ºÎ¿©

±ÇÇÑ ºÎ¿©

±ÇÇÑ ºÎ¿©

¼ÒÀ¯ÀÚÀÇ Å×À̺í À妽º

¼ÒÀ¯ÀÚÀÇ À妽º

À妽º

À妽º

Å×À̺í Á¦¾à Á¶°Ç

Å×À̺í Á¦¾à Á¶°Ç

Å×À̺í Á¦¾à Á¶°Ç

Å×À̺í Á¦¾à Á¶°Ç

 

 

Æ®¸®°Å

 

tablespace ¸ðµå : À̵¿ °¡´ÉÇÑ Å×ÀÌºí½ºÆäÀ̽º¸¦ »ç¿ëÇÏ¿© ¿À¶óŬ µ¥ÀÌŸº£À̽ºÀÇ ÀϺθ¦ À̵¿ÇÏ¿© ´Ù¸¥ ¿À¶óŬ µ¥ÀÌ

                            Å¸º£À̽º¿¡ ¿¬°áÇÔÀ¸·Î½á º»ÁúÀûÀ¸·Î´Â µ¥ÀÌŸº£À̽º°£¿¡ Å×ÀÌºí½ºÆäÀ̽º¸¦ À̵¿ÇÏ´Â ÀÛ¾÷À» ¼öÇà

                            ÇÒ ¼ö ÀÖ½À´Ï´Ù. µ¥ÀÌŸ ÆÄÀÏÀ» º¹»çÇϰí Å×ÀÌºí½ºÆäÀ̽ºÀÇ ±¸Á¶Á¤º¸¸¦ ÅëÇÕÇϱ⸸ Çϸé Å×ÀÌºí½º

                            ÆäÀ̽º¸¦ À̵¿ÇÒ ¼ö ÀÖÀ¸¹Ç·Î À̵¿°¡´ÉÇÑ Å×ÀÌºí ½ºÆäÀ̽º¸¦ »ç¿ëÇÏ¿© µ¥ÀÌŸ¸¦ À̵¿ÇÏ´Â °ÍÀÌ µ¿

                            ÀÏÇÑ µ¥ÀÌŸ¿¡ ´ëÇØ import/export¸¦ ¼öÇàÇÏ´Â °Íº¸´Ù ºü¸¨´Ï´Ù.

 

3. ½ÇÇà

   1) ´ëÈ­½Ä ½ÇÇà¹æ½Ä

       $ exp <ENTER>

          Export: Release 9.2.0.2.0 - Production on Tue Mar 23 14:22:00 2004

          Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

          Username:scott             <ENTER>                  oracle Á¢¼Ó¿¡ ÇÊ¿äÇÑ userid¸¦ ÀÔ·Â

          Password:tiger              <ENTER>                  oracle Á¢¼Ó¿¡ ÇÊ¿äÇÑ password¸¦ ÀÔ·Â

 

          Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production

          With the Partitioning, OLAP and Oracle Data Mining options

          JServer Release 9.2.0.2.0 - Production

          Enter array fetch buffer size: 4096 >       <ENTER>    µ¥ÀÌŸ ¹öÆÛÀÇ Å©±â, ±×³É ¿£ÅÍŰ ÀԷ½à µðÆúÆ® °ª Àû¿ë

          Export file: expdat.dmp > asean.dmp     <ENTER>    ÀͽºÆ÷Æ®µ¥´Â ÆÄÀÏÀÇ À§Ä¡

          (2)U(sers), or (3)T(ables): (2)U >3         <ENTER>    ÀͽºÆ÷Æ®ÇÒ ´ë»óÀ» user´ÜÀ§·Î ÇÒ °ÍÀÎÁö, table·Î ÇÒ

                                                                                          °ÍÀÎÁö¸¦ °áÁ¤

          Export table data (yes/no): yes >           <ENTER>    µ¥ÀÌŸ¸¦ Æ÷ÇÔÇØ¼­ ÀͽºÆ÷Æ® ÇÒ °ÍÀÎÁö¸¦ °áÁ¤

          Compress extents (yes/no): yes >        <ENTER>    ÇöÀç ¿ÀºêÁ§Æ®¿¡ ÇÒ´çµÈ ÀͽºÅÙÆ® ÀüºÎÀÇ Å©±â¿Í °°Àº

                                                                                          ÇϳªÀÇ Ãʱâ ÀͽºÅÙÆ®¸¦ »ý¼ºÇÏ´Â Äڵ带 ¸¸µå´Â °Í

 

          Export done in UTF8 character set and AL16UTF16 NCHAR character set

          server uses AL32UTF8 character set (possible charset conversion)

          About to export specified tables via Conventional Path ...

          Table(T) or Partition(T:P) to be exported: (RETURN to quit) >emp  <ENTER> ÀͽºÆ÷Æ®ÇÒ Å×À̺í À̸§À» °áÁ¤

          . . exporting table                 TBL_HB_COMPANY      24443 rows exported

          Table(T) or Partition(T:P) to be exported: (RETURN to quit) >        <ENTER>

          Export terminated successfully without warnings.

 

   2) ¸í·ÉÇà ¸ðµå

       - table ´ÜÀ§ export ¿¹Á¦

       $ exp scott/tiger file=business.dmp tables=tbl_hb_company, tbl_hb_catalog rows=y;

       - user ´ÜÀ§ export ¿¹Á¦

       $ exp scott/tiger file=asean.dmp owner=scott;

       - tablespace ´ÜÀ§ export ¿¹Á¦

       $ exp scott/tiger file=asean_ts.dmp TRANSPORT_TABLESPACE=y tablespace=ts_emp log=asean_ts.log;

       - database ´ÜÀ§ export ¿¹Á¦

       $ exp system/manager file=asean_ful.dmp full=y;

          full ¿É¼ÇÀ» »ç¿ëÇϱâ À§Çؼ­´Â ±ÇÇÑ ÀÖ´Â »ç¿ëÀÚ¸¸ °¡´ÉÇÕ´Ï´Ù.

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

iWiz (2004-03-25 01:14:36)  
ÆäÀÌÁö Á¶È¸¼ö°¡ ´Ã¾î³­´Ù°í ÁÁ¾ÆÇÏ´õ´Ï ÄÁÅÙÃ÷ °¡°ø¿¡ ´õ ½Å°æÀ» ±â¿ï¿´±º¿ä! Á¶È¸¼ö Á¶±Ý ´õ ³ô¾ÆÁö¸é À¯·áȸ¿øÁ¦·Î ¹Ù²ß½Ã´Ù. ¤»¤»


22   UTF Charset¿¡¼­ ¿À¶óŬ¿¡ ³ÖÀ» ¼ö ÀÖ´Â ÃÖ´ë ¹®ÀÚ¿­ ±æÀÌ °è»ê  iWiz 2004/01/04 7110 33
21   RedHat 8.0¿¡¼­ MySQL ¿ÜºÎ Á¢¼Ó ¹®Á¦ ÇØ°á ¹æ¹ý  iWiz 2004/01/04 9273 34
20   MySQL °ü·Ã Àâ´ÙÇÑ ¸í·É¾î ¸ðÀ½  iWiz 2004/01/04 6640 35
19   SAP DB ¼³Ä¡¹æ¹ý  iWiz 2004/01/04 7415 30
18   MySQL DB ´ýÇÁ ¹× ¸®½ºÅä¾î ¸í·É  iWiz 2004/01/04 5338 36
17   ER Diagram ÀÛ¼º ÇÁ·Î±×·¥ ERWin »ç¿ë ¹æ¹ý  iWiz 2004/04/04 13412 38
16   ¿À¶óŬ ±âº» ¸í·É¾î Á¤¸® [2]  iWiz 2004/04/07 11589 42
15   ¿Ü¿öµµ ¿Ü¿öµµ ±î¸Ô´Â ¿À¶óŬ ÇÔ¼ö (¹Ø¿¡²¨ ÆÛ°¡´Â ´ë½Å ¤¾) [1]  ÀÌÁØÈ£ 2004/07/15 12206 43
14   ¿À¶óŬ Architecture  ¹ÚÁã 2004/03/19 6045 32
13   µ¥ÀÌŸ º£À̽ºÀÇ STARTUP°ú SHUTDOWN  ¹ÚÁã 2004/03/19 6443 34
12   NULLÀ̶õ?? [2]  ¹ÚÁã 2004/03/22 8289 32
11   ºñ±³ / ³í¸® ¿¬»êÀÚ ¹× ¿¬»ê ¿ì¼± ¼øÀ§  ¹ÚÁã 2004/03/22 9574 41
  Export À¯Æ¿¸®Æ¼ [1]  ¹ÚÁã 2004/03/23 5924 35
9   ¿À¶óŬÀÇ Constraint(Á¦¾àÁ¶°Ç)  ¹ÚÁã 2004/03/26 37892 38
8   ¿À¶óŬ¿¡¼­ÀÇ ¹é¾÷...  ¹ÚÁã 2004/03/30 6567 40

1 [2]
 

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