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: °Å±â¿¡ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ¿©·¯ °¡Áö ÇØ°á ¹æ¹ý :
- Import the export file by using a user with database administrator privileges, with FROMUSER and TOUSER parameters. FROMUSER¿Í µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±ÇÇÑÀ» °¡Áø »ç¿ëÀÚ TOUSER ¸Å°³ º¯¼ö¿Í ÇÔ²² »ç¿ëÇÏ¿© °¡Á®¿À±â ³»º¸³»±â ÆÄÀÏ,.
- 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. ÀÌ ÀϽÃÀûÀ¸·Î ¼öÀÔ ÈÄ ±ÇÇÑÀ» Ãë¼Ò ÇÒ ¼öÀÖ½À´Ï´Ù.
- 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 ³» µðÁöÅÐ »ýȰ Æ÷·³ .
Related Articles °ü·Ã ±â»ç
- Oracle Database Import Error 3113/3114 Oracle µ¥ÀÌÅͺ£À̽º °¡Á®¿À±â ¿À·ù 3,114ºÐÀÇ 3,113
- Oracle EXP-00091 Error When Export Database ¿À¶óŬ ÀÖµµ·Ï EXP - 00091 ¿À·ù°¡ ¹ß»ýÇßÀ» ¶§ µ¥ÀÌÅͺ£À̽º ³»º¸³»±â
- IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database ÀÓÇÁ - 00016 Çʼö ¹®ÀÚ ÁýÇÕ º¯È¯ÀÌ Áö¿øµÇÁö Oracle µ¥ÀÌÅͺ£À̽º·Î °¡Á®¿Ã ¶§ ¿À·ù
- Manual and Clean Uninstall Oracle for Windows ¸Å´º¾ó ¹× û¼Ò¸¦ Á¦°Å Windows ¿ë ¿À¶óŬ
- Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error , ¶Ç´Â ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ÆÄƼ¼Ç ºÐÇÒ Ãß°¡ ¸¸µé±â ORA - 14080 ¿À·ù¿Í ÇÔ²² ½ÇÆÐ
- ORA-00942 Table or View Does Not Exist Oracle Error ¿À¶ó - 00942 Å×À̺íÀ̳ªº¸±â´Â Oracle ¿À·ù°¡ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù
- ORA-02449 Oracle Drop Table Error ¿À¶ó - 02449 ¿À¶óŬ µå·Ó Å×ÀÌºí ¿À·ù
- Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error ¿À¶óŬÀº ORA - 01658 ¼¼±×¸ÕÆ®¿¡ ´ëÇÑ ¿À·ù Å×À̺íÀÇ Ãʱ⠹üÀ§¸¦ ¸¸µé ¼ö¾ø½À´Ï´Ù
- Oracle JDeveloper Reviews ¿À¶óŬÀº JDeveloper ¸®ºä
- ORA-01502 Oracle Index in Unusable State ORA - 01502 ¿À¶óŬ Áö¼ö´Â ºÒ°¡´É »óÅ¿¡
































