{"id":4644,"date":"2021-11-04T11:33:00","date_gmt":"2021-11-04T02:33:00","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4644"},"modified":"2023-04-14T15:54:19","modified_gmt":"2023-04-14T06:54:19","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%ed%8e%8c%ed%94%84-%ec%a0%81%ec%9e%ac-impdp-%ec%8b%9c-%ec%97%90%eb%9f%ac%ea%b0%80-%eb%b0%9c%ec%83%9d-%ed%95%a0-%ea%b2%bd%ec%9a%b0-oracle-18c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4644","title":{"rendered":"\ub370\uc774\ud130\ud38c\ud504 \uc801\uc7ac IMPDP \uc5d0\ub7ec\uac00  \ubc1c\uc0dd \ud560 \uacbd\uc6b0 ( Oracle 18c ~ )"},"content":{"rendered":"<p><strong><span style=\"font-size: x-large;\">Import with the <u><span style=\"color: #0000ff;\">CONTINUE_LOAD_ON_FORMAT_ERROR<\/span><\/u>\u00a0 \uae30\ub2a5 \ucd94\uac00<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Oracle 12c \uae4c\uc9c0\ub294 IMPORT\uc2dc Stream format error\uac00 \ubc1c\uc0dd\ub418\uba74, \ub85c\ub529\uc774 \uc911\ub2e8 \ub429\ub2c8\ub2e4. <\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">\u00a0\u00a0 \u2022 \uc77c\ubc18\uc801\uc73c\ub85c Stream format error\ub294 \uc190\uc0c1\ub41c dump \ud30c\uc77c\uc5d0\uc11c \ubc1c\uc0dd\ub429\ub2c8\ub2e4. (\ud30c\uc77c \uae68\uc9d0 , \ub370\uc774\ud130 \uc801\uc7ac \uc624\ub958 )<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">\u00a0\u00a0 \u2022 Import \ub418\uace0\uc788\ub358 \uc804\uccb4 \ub370\uc774\ud130\uac00 Rollback \ub429\ub2c8\ub2e4<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">\u00a0\u00a0 \u2022 \ud574\uacb0\ubc29\ubc95 :\u00a0 \ub2e4\uc2dc export\/import \ud568 . EXPDP\/IMPDP<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ub370\uc774\ud130 \ud38c\ud504 \uc791\uc5c5 10 \uc2dc\uac04\uc774\ub098 \uae30\ub2e4\ub838\ub294\ub370 \uc2e4\ud328 \u2026. <\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ticktocktech.com\/ottawa-computer-repair\/wp-content\/uploads\/sites\/9\/2019\/07\/lady-mad-at-the-computer-1200x800.jpg?resize=430%2C287&#038;ssl=1\" alt=\"Types of Computer Hangs Explained - TickTockTech - Computer Repair Ottawa\" width=\"430\" height=\"287\" data-recalc-dims=\"1\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>*. Oracle 18c \ubd80\ud130 \uc0c8\ub85c \ub098\uc628 \uae30\ub2a5<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #0000ff; font-size: large;\">CONTINUE_LOAD_ON_FORMAT_ERROR option: <\/span><\/strong><\/p>\n<p><strong><span style=\"color: #0000ff; font-size: large;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2022\u00a0 \uc804\uccb4\uac00 Rollback \ub418\ub294 \ub300\uc2e0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \ub370\uc774\ud130\uc758 granule\uc740 Skip \ub429\ub2c8\ub2e4. <\/span><\/strong><\/p>\n<p><strong><span style=\"color: #0000ff; font-size: large;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2022\u00a0 \ub2e4\uc74c granule \ubd80\ud130 \ub2e4\uc2dc Loading \uc2dc\uc791\ud558\uae30 \ub54c\ubb38\uc5d0 \uc218\ubc31 ~ \uc218\ucc9c \ud589\uc774 Skip\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #0000ff; font-size: large;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2022\u00a0 Stream Format \uc5d0\ub7ec\uac00 \uc5c6\ub294 \ud589\uc744 \ucc3e\uc544 \ub370\uc774\ud130\ub97c \uacc4\uc18d \ub85c\ub4dc \ud569\ub2c8\ub2e4.<\/span><\/strong><\/p>\n<p><span style=\"font-size: large;\"><strong><span style=\"color: #000000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2022\u00a0 Network Mode Import\uc5d0\uc11c\ub294 \uc635\uc158\uc774 \ubb34\uc2dc\ub429\ub2c8\ub2e4. (\uc18c\uc2a4\uac00 DB Link\uc778 \uacbd\uc6b0)<\/span><\/strong> <\/span><\/p>\n<p><span style=\"font-size: large;\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-29.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-28.png?resize=640%2C46\" alt=\"image\" width=\"640\" height=\"46\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Import with the CONTINUE_LOAD_ON_FORMAT_ERROR\u00a0 \uae30\ub2a5 \ucd94\uac00 &nbsp; Oracle 12c \uae4c\uc9c0\ub294 IMPORT\uc2dc Stream format error\uac00 \ubc1c\uc0dd\ub418\uba74, \ub85c\ub529\uc774 \uc911\ub2e8 \ub429\ub2c8\ub2e4. \u00a0\u00a0 \u2022 \uc77c\ubc18\uc801\uc73c\ub85c Stream format error\ub294 \uc190\uc0c1\ub41c dump \ud30c\uc77c\uc5d0\uc11c \ubc1c\uc0dd\ub429\ub2c8\ub2e4. (\ud30c\uc77c \uae68\uc9d0 , \ub370\uc774\ud130 \uc801\uc7ac \uc624\ub958 ) \u00a0\u00a0 \u2022 Import \ub418\uace0\uc788\ub358 \uc804\uccb4 \ub370\uc774\ud130\uac00 Rollback \ub429\ub2c8\ub2e4 \u00a0\u00a0 \u2022 \ud574\uacb0\ubc29\ubc95 :\u00a0 \ub2e4\uc2dc export\/import \ud568 . EXPDP\/IMPDP &nbsp; \ub370\uc774\ud130 \ud38c\ud504 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[1217,287],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/08\/oracletips.jpg?fit=650%2C361","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4644"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4644"}],"version-history":[{"count":4,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4644\/revisions"}],"predecessor-version":[{"id":4821,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4644\/revisions\/4821"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/4141"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4644"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}