\uc11c\ub85c \ub2e4\ub978 \ubc84\uc804\uc758 Oracle\ub85c import\/export \ud560 \uacbd\uc6b0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
\uc608\ub97c \ub4e4\uc5b4 export\ub97c 11g client\ub85c, import\ub97c 10G client\ub85c \ud558\ub294 \uacbd\uc6b0 ( \uc11c\ubc84 \ubc84\uc804\uacfc\ub294 \ubb34\uad00\ud558\uac8c imp, exp\u00a0\ub610\ub294 imp.exe, exp.exe \uc2e4\ud589 \ud30c\uc77c \uc790\uccb4\uc758 \ubc84\uc804\uc744 \ub530\uc9c4\ub2e4 ) imp\uc640 exp\ub294 \ud638\ud658\uc131\uc774 \uc804\ud600 \uc5c6\ub2e4.<\/p>\n
\uc774 \uacbd\uc6b0 expdb \ub610\ub294 imp \ud560 \ubc84\uc804\uacfc \ub3d9\uc77c\ud55c client\ub85c \ub2e4\uc2dc exp \ubc1b\uc544\uc57c \ud558\uc9c0\ub9cc \uc0ac\uc815\uc774 \uc5ec\uc758\uce58 \uc54a\ub294 \uacbd\uc6b0 \uc751\uae09\uc870\uce58\ub85c \ubb38\uc790\uc5f4\ub9cc \ubcc0\uacbd\ud558\uc5ec \uc2dc\ub3c4\ud574 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n
\uc608\ub97c \ub4e4\uc5b4 11.0.2\uc758 client\ub85c<\/p>\n
exp user_id\/passwd@fromOracle<\/a>\u00a0 tables=aa file=aa.dmp<\/pre>\n\uc640 \uac19\uc774 export \ubc1b\uc544 10.2.0.1\uc758 client\ub85c import \ud574\uc57c \ud558\ub294 \uacbd\uc6b0<\/p>\n
imp user2\/pass@toOracle<\/a> fromuser=user_id touser=user2 file=aa.dmp ignore=y log=aa.log<\/pre>\n\uc640 \uac19\uc774 \uc2e4\ud589\uc744 \ud55c \uacbd\uc6b0<\/p>\n
IMP-00010: not a valid export file, header failed verification\r\n\r\nIMP-00000: Import terminated unsuccessfully<\/pre>\n\uc640 \uac19\uc740 \uc5d0\ub7ec\ub97c \ubc49\uc5b4 \ub0b4\uace0 imp\uac00 \uc548\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 aa.dmp \ud30c\uc77c\uc744 \uc5f4\uc5b4\ubcf4\uba74<\/p>\n
\u300c\u300cNEXPORT:V11.00.02\r\nUUSER_ID\r\n\r\n\r\nRTABLES\r\n...<\/pre>\n\uc640 \uac19\uc740 \ub0b4\uc6a9\uc774 \ubcf4\uc778\ub2e4.<\/p>\n
\uc774 \uccab\uc9f8\uc904\uc758\u300c\u300cNEXPORT:V11.00.02\ub97c \u300c\u300cNEXPORT:V10.02.01\ub85c \ubc14\uafb8\uace0 \ub2e4\uc2dc import\ub97c \uc2e4\ud589\ud558\uba74 \ub418\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4!!<\/p>\n
\uc774 \ub54c \ud30c\uc77c\uc744 \uc798\ubabb \uc5f4\uc5b4 \uc800\uc7a5\ud558\uba74 binary \ub370\uc774\ud130\uac00 \uae68\uc838 \ud30c\uc77c\uc744 \ubabb \uc4f8\uc218\uac00 \uc788\uc73c\ubbc0\ub85c \uba3c\uc800 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ubc31\uc5c5 \ubc1b\uace0 \ubb38\uc790\uc5f4 \ubcc0\uacbd\uc740 ultra editor \uac19\uc740 \uace0\uc131\ub2a5 \uc5d0\ub514\ud130\uc758 “\ud30c\uc77c\ub0b4\uc5d0\uc11c \ubb38\uc790\uc5f4 \ubcc0\uacbd”\u00a0\uae30\ub2a5\u00a0\ub610\ub294 OS \uc0c1\uc5d0\uc11c \ud30c\uc77c \ub0b4 \ubb38\uc790\uc5f4\uc744 \uc9c1\uc811 \ubcc0\uacbd\ud558\ub294 (Linux\uc758 sed\u00a0 \ud504\ub85c\uadf8\ub7a8\uacfc \uac19\uc740 ) \ud504\ub85c\uadf8\ub7a8\uc744 \ud65c\uc6a9\ud574\uc57c \ub370\uc774\ud130 \ud30c\uc77c\uc774 \uae68\uc838 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ub0a0\ub9ac\ub294 \uacbd\uc6b0\ub97c \ubc29\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\ubc18\ub4dc\uc2dc \ub3d9\uc77c\ud55c client\ub97c \uc0ac\uc6a9\ud558\uae30\ub97c \uad8c\uc7a5\ud558\uace0 \uadf8 \ubc29\ubc95\uc774 \uc815\uc0c1\uc801\uc778 \ubc29\ubc95\uc774\ub098 \uac00\ub054\uc740 \uac15\uc81c\ub85c \ubc84\uc804\uc744 \ubc14\uafd4\uc11c \uc2e4\ud589\uc744 \ud574\uc11c \uc131\uacf5\ud558\uae30\ub3c4 \ud55c\ub2e4.<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc11c\ub85c \ub2e4\ub978 \ubc84\uc804\uc758 Oracle\ub85c import\/export \ud560 \uacbd\uc6b0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \uc608\ub97c \ub4e4\uc5b4 export\ub97c 11g client\ub85c, import\ub97c 10G client\ub85c \ud558\ub294 \uacbd\uc6b0 ( \uc11c\ubc84 \ubc84\uc804\uacfc\ub294 \ubb34\uad00\ud558\uac8c imp, exp\u00a0\ub610\ub294 imp.exe, exp.exe \uc2e4\ud589 \ud30c\uc77c \uc790\uccb4\uc758 \ubc84\uc804\uc744 \ub530\uc9c4\ub2e4 ) imp\uc640 exp\ub294 \ud638\ud658\uc131\uc774 \uc804\ud600 \uc5c6\ub2e4. \uc774 \uacbd\uc6b0 expdb \ub610\ub294 imp \ud560 \ubc84\uc804\uacfc \ub3d9\uc77c\ud55c client\ub85c \ub2e4\uc2dc exp \ubc1b\uc544\uc57c \ud558\uc9c0\ub9cc \uc0ac\uc815\uc774 \uc5ec\uc758\uce58 \uc54a\ub294 \uacbd\uc6b0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,10],"tags":[],"class_list":["post-289","post","type-post","status-publish","format-standard","hentry","category-it","category-oracle"],"_links":{"self":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=289"}],"version-history":[{"count":1,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}