IMP-00013 Oracle Import Error IMP - 00013 ¿À¶óŬ °¡Á®¿À±â ¿À·ù

When trying to import an export dump file that has been exported by a DBA, the following error occurs: ¶§ ³»º¸³»·Á¸é ±×°ÍÀº DBA, ´ÙÀ½°ú °°Àº ¿À·ù·Î ³»º¸³½¿Ô´Ù ´ýÇÁ ÆÄÀÏÀ» °¡Á®¿À·Á ¹ß»ýÇÕ´Ï´Ù :

IMP-00013: only a DBA can import a file exported by another DBA IMP - 00013 : ÆÄÀÏÀ» ´Ù¸¥Àº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù

The issue is because the privileges needed to import an export dump file generated by a database administrator do not exist. ±ÇÇÑÀÌ Àֱ⠶§¹®¿¡ ¼öÃâ ´ýÇÁ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¿¡ ÀÇÇØ »ý¼ºµÈ ÆÄÀÏÀ» °¡Á®¿À´Â µ¥ ÇÊ¿äÇÑ Á¸ÀçÇÏÁö ¾Ê´Â ¹®Á¦ÀÔ´Ï´Ù. Only a database administrator can import a export file dumped by another database administrator. µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¸¸ÀÌ ¼öÃâ ´Ù¸¥ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¿¡ ÀÇÇØ ¹ö·ÁÁø ÆÄÀÏÀ» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù.

There are several workarounds to solve the problems: °Å±â¿¡ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ¿©·¯ °¡Áö ÇØ°á ¹æ¹ý :

  1. Import the export file by using a user with database administrator privileges, with FROMUSER and TOUSER parameters. FROMUSER¿Í µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±ÇÇÑÀ» °¡Áø »ç¿ëÀÚ TOUSER ¸Å°³ º¯¼ö¿Í ÇÔ²² »ç¿ëÇÏ¿© °¡Á®¿À±â ³»º¸³»±â ÆÄÀÏ,.
  2. Grant the sufficient privileges (ie. database administrator) to the user. »ç¿ëÀÚ¿¡°Ô ÃæºÐÇÑ ±ÇÇÑÀ» ºÎ¿© (Áï µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ). To do this, use the SQL*Plus and issue command ¡°Grant DBA to db_user;¡±. ÀÌ·¸°ÔÇÏ·Á¸é db_user "±×·£Æ®Àº DBA´Â SQL * Plus ¹× ¸í·ÉÀ» »ç¿ëÇÏ¿© ¹®Á¦;". This can be done temporarily by revoking the privileges after the import. ÀÌ ÀϽÃÀûÀ¸·Î ¼öÀÔ ÈÄ ±ÇÇÑÀ» Ãë¼Ò ÇÒ ¼öÀÖ½À´Ï´Ù.
  3. Re-export the dump file from a non-DBA user account. ´Ù½Ã - ´ýÇÁ ÆÄÀÏ -Àº DBA°¡ ¾Æ´Ñ »ç¿ëÀÚ °èÁ¤À» ³»º¸³¾ ¼öÀÖ½À´Ï´Ù.

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. Áß¿ä :ÀÌ ±â°è´Â "º¸Áõµµ¾øÀÌÀÖ´Â ±×´ë·Î"Á¦°øµË´Ï´Ù ÆäÀÌÁö¸¦ ¹ø¿ªÇß´Ù. Machine translation may be difficult to understand. ±â°è ¹ø¿ªÀ» ÀÌÇØÇϱ⠾î·Á¿ï ¼öÀÖ½À´Ï´Ù. Please refer to À» ÂüÁ¶ÇϽñ⠹ٶø´Ï´Ù original English article ¿ø·¡ ¿µ¾î ¹®¼­ whenever possible. ¾ðÁ¦µç °¡´ÉÇÕ´Ï´Ù.

Share and contribute or get technical support and help at °øÀ¯¿Í ±â¿©Çϰųª ±â¼ú Áö¿ø°ú¿¡ µµ¿òÀÌ My Digital Life Forums ³» µðÁöÅÐ »ýȰ Æ÷·³ .



Leave a Reply ȸ½ÅÀ» ³²°ÜÁÖ¼¼¿ä

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> ÀÌ·¯ÇÑ ÅÂ±× : title="">Àº <a href="" »ç¿ëÇÒ ¼öÀÖ½À´Ï´Ù <abbr title=""> <acronym title="">ÀÇ <b> <blockquote cite=""> <cite>ÀÇ <code> <¹ã ³¯Â¥ = "">Àº <em>°¡ <i> <q cite=""> <strike>ÀÇ <strong>

Subscribe without commenting ÄÚ¸àÆ®¸¦ ±¸µ¶ÇÏÁö ¾Ê°í


Custom Search

New Articles »õ ¹®¼­

Incoming Search Terms for the Article ¿¡ ´ëÇÑ °Ë»ö ¾à°ü¹Þ´Â Á¦

IMP-00013 IMP - 00013 - - IMP-00013: only a DBA can import a file exported by another DBA IMP - 00013 : ÆÄÀÏÀ» ´Ù¸¥Àº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - only a DBA can import a file exported by another DBA ´Ù¸¥ ÆÄÀÏÀº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - IMP-00013: IMP - 00013 : - - oracle IMP-00013 ¿À¶óŬÀÇ IMP - 00013 - - IMP-00013: only a DBA can import a file exported by another DBA IMP - 00013 : ÆÄÀÏÀ» ´Ù¸¥Àº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - IMP 00013 IMP 00013 - - imp oracle ÀÓÇÁ ¿À¶óŬ - - grant import oracle ºÎ¿©¸¦ °¡Á®¿Ã ¿À¶óŬ - - IMP-00013 ORACLE IMP - 00013Àº ORACLE - - only a DBA can import a file exported by another DBA ´Ù¸¥ ÆÄÀÏÀº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - grant import ºÎ¿© ¼öÀÔ - - oracle imp IMP-00013 ¿À¶óŬ ÀÓÇÁ IMP - 00013 - - oracle grant import ¿À¶óŬ ºÎ¿© ¼öÀÔ - - oracle imp dba ¿À¶óŬ ÀÓÇÁ dBAÀÇ - - ora-00013 ¿À¶ó - 00013 - - "imp-00013: only a DBA can import a file exported by another DBA" "ÀÓÇÁ - 00013 :¿¡¸¸Àº DBA"Àº DBA·Î ³»º¸³½ ÆÄÀÏÀ» ´Ù¸¥ °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - oracle imp error ¿À¶óŬ ÀÓÇÁ ¿À·ù - - oracle imp ¿À¶óŬ ÀÓÇÁ - - imp 00013 oracle ÀÓÇÁ 00013 ¿À¶óŬ - - 00013 00013 - - imp-00013 ÀÓÇÁ - 00013 - - "imp-00013" oracle "ÀÓÇÁ - 00013"¿À¶óŬ - - IMP-00013: only a DBA IMP - 00013 :¿¡¸¸Àº DBA - - oracle imp utility database user privileges ÀÓÇÁ À¯Æ¿¸®Æ¼ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ±ÇÇÑ - - IMP-00013: only DBA IMP - 00013 : Àü¿ëÀº DBA - - IMP-00013: only a DBA can import a file exported by another DBA. IMP - 00013 : ÆÄÀÏÀ» ´Ù¸¥Àº DBA¿¡ ÀÇÇØ ¼öÃâÀº DBA¸¸À» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù. - - IMP+ORACLE IMP +Àº ORACLE - - oracle imp grants ¿À¶óŬ ÀÓÇÁ ±³ºÎ±Ý - - export grant oracle ¼öÃâÀ» ºÎ¿© ¿À¶óŬ - - grants needed to perform import +oracle ±³ºÎ±Ý ¼öÀÔÀ» ¼öÇàÇϱâ À§ÇØ ÇÊ¿äÇÑ + ¿À¶óŬ - - imp-00013 ora ÀÓÇÁ - 00013 ¿À¶ó ' - - oracle grant IMPORT permission ¿À¶óŬ ±ÇÇÑÀ» ºÎ¿© °¡Á®¿À±â - - oracle import grant ¿À¶óŬÀÇ ¼öÀÔÀ» ºÎ¿© - - problem oracle imp ¹®Á¦´Â ¿À¶óŬÀÇ ÀÓÇÁ - - oracle grants import ¿À¶óŬ ±³ºÎ±Ý ¼öÀÔ - - grant import user oracle »ç¿ëÀÚ°¡ ¿À¶óŬÀ» ºÎ¿© ¼öÀÔ - - imp on oracle ¿À¶óŬ¿¡ ÀÓÇÁ - - imp:00013 ÀÓÇÁ : 00013 - - only dba can import oracle another dba dBAÀÇ ´Ù¸¥ dBAÀÇ ¿À¶óŬÀÌ °¡Á®¿Ã ¼öÀÖ´Â À¯ÀÏÇÑ - - oracle how can i know which users can import imp ¿À¶óŬÀº »ç¿ëÀÚ°¡ ¾î¶»°Ô ¾Ë ¼ö ÀÓÇÁ´Â °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - Oracle "IMP-00013" ¿À¶óŬÀº "IMP - 00013" - - oracle import dba rights required ¿À¶óŬÀÌ °¡Á®¿Ã dBAÀÇ ±Ç¸®´Â Çʼö - - ora 00013 ¿À¶ó 00013 - - oracle import privileges ¿À¶óŬÀº ¼öÀÔ ±ÇÇÑÀ» - - grant import privileges to an oracle database user Oracle µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÀÚ¿¡°Ô ±ÇÇÑÀ» ºÎ¿© ¼öÀÔ - - how to imp oracle ¿À¶óŬ ¾î¶»°Ô ÀÓÇÁ·Î - - import grant commands ¼öÀÔ ºÎ¿© ¸í·É - - only dba can import exported by dba oracle dBAÀÇ dBAÀÇ ½ÅŹ¿¡ ÀÇÇØ¼­¸¸ ¼öÃâÀ» °¡Á®¿Ã ¼öÀÖ½À´Ï´Ù - - GRANT IMP ºÎ¿© IMP - -