{"id":11958,"date":"2022-10-03T15:10:08","date_gmt":"2022-10-03T06:10:08","guid":{"rendered":"https:\/\/prodskill.com\/?p=11958"},"modified":"2022-10-05T00:09:13","modified_gmt":"2022-10-04T15:09:13","slug":"oracle-character-set-migration-8-datapump-export-import","status":"publish","type":"post","link":"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/","title":{"rendered":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)"},"content":{"rendered":"\n<p>\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\ubcc4\ub3c4 \uad6c\ud604\uc774 \ud544\uc694\ud55c \ubc29\ubc95\uc740 Oracle\uc5d0\uc11c \ubcc0\ud658\uc744 \ubcf4\uc7a5\ud558\uc9c0 \uc54a\uace0 \uad6c\ud604\ud55c \uc0ac\uc6a9\uc790\uac00 \ubcc0\ud658\uc744 \ubcf4\uc7a5\ud574\uc57c \ud558\ubbc0\ub85c \uae30\uc220 \uac80\uc99d\uacfc \ub2e4\uc591\ud55c \ucf00\uc774\uc2a4\uc5d0 \ub300\ud558\uc5ec \ud14c\uc2a4\ud2b8\ub97c \uac70\uccd0 \uc815\ud655\uc131\uc744 \ud655\uc778\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804 \uae00\uc5d0\uc11c \uc774\uc5b4\uc9c0\ub294 \ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/oracle-character-set-migration-7-ko16mswin949-csscan-result\/\">Oracle Character Set \ubcc0\ud658(7): 5.4. KO16MSWIN949 \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;\ubaa9\ucc28&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/#6_%EC%82%AC%EC%9A%A9%EC%9E%90_%EA%B5%AC%ED%98%84_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\" >6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/#61_Third_party_tool_%EC%A0%81%EC%9A%A9_%EB%B0%A9%EB%B2%95_%E2%80%93_ETL_%EB%93%B1\" >6.1. Third&nbsp;party&nbsp;tool&nbsp;\uc801\uc6a9&nbsp;\ubc29\ubc95&nbsp;&#8211;&nbsp;ETL&nbsp;\ub4f1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/#62_Oracle_Utility_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >6.2. Oracle Utility \ud65c\uc6a9 \ubc29\ubc95<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/#621_%EB%B0%A9%EB%B2%951_Data_Pump_ExportImport\" >6.2.1. \ubc29\ubc951)&nbsp;Data&nbsp;Pump&nbsp;Export\/Import<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/#622_%EB%B0%A9%EB%B2%952_SQLLoader\" >6.2.2. \ubc29\ubc952) SQL*Loader<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"6.\uad6c\ud604\uc774_\ud544\uc694\ud55c_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"6_%EC%82%AC%EC%9A%A9%EC%9E%90_%EA%B5%AC%ED%98%84_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\"><\/span>6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6.1._Third_party_tool_\uc801\uc6a9_\ubc29\ubc95_-_ETL_\ub4f1\"><span class=\"ez-toc-section\" id=\"61_Third_party_tool_%EC%A0%81%EC%9A%A9_%EB%B0%A9%EB%B2%95_%E2%80%93_ETL_%EB%93%B1\"><\/span>6.1. Third&nbsp;party&nbsp;tool&nbsp;\uc801\uc6a9&nbsp;\ubc29\ubc95&nbsp;&#8211;&nbsp;ETL&nbsp;\ub4f1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uc2dc\uc7a5\uc5d0 \uc798 \uc54c\ub824\uc9c4 ETL tool(\uc608: Informatica PowerCenter, IBM DataStage \ub4f1)\uc744 \ud65c\uc6a9\ud558\uc5ec Character Set \ubcc0\ud658\uc744 \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<p>\ub0b4\uac8c\ub294 \uc9c1\uc811 \uacbd\ud5d8\uc774 \uc5c6\ub294 \ubc29\ubc95\uc774\uace0 \uac00\ub2a5\ud558\ub2e4\ub294 \uac83\ub9cc \uc54c\uace0 \uc788\uc5b4 \uc790\uc138\ud55c \ubc29\ubc95\uc744 \uae30\uc220\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\ub9cc,&nbsp;\uc544\ub798&nbsp;\uace0\ub824\uc0ac\ud56d\uc5d0&nbsp;\ub300\ud574\uc11c\ub9cc&nbsp;\uac80\ud1a0\ud558\uae30&nbsp;\ubc14\ub780\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\uac01 \uc81c\ud488\uc740 \uad6c\ub9e4\uc5d0 \ub530\ub978 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud558\uac70\ub098, \uae30 \uad6c\ub9e4\ub418\uc5b4 \uc788\ub354\ub77c\ub3c4 \uac1c\ubc1c \uc778\uac74\ube44\uac00 \ucd94\uac00\uc801\uc73c\ub85c \ud544\uc694\ud568<\/li><li>Open Source\uc778 TOS(Talend Open Studio)-DI, Pentaho Kettle \ub4f1\ub3c4 \uace0\ub824\ud574 \ubcfc \uc218 \uc788\uc74c<\/li><li>Source DB\uc758 Data\ub97c file\ub85c write\ud558\uace0 Target DB\uc5d0 file\uc744 \uc77d\uc5b4\uc11c insert\ud558\ub294 \ubc29\uc2dd\uc77c \uacbd\uc6b0, column \uad6c\ubd84\uc790\uc640 row \uad6c\ubd84\uc790\uac00 \ub370\uc774\ud130 value\uc5d0 \ud3ec\ud568\ub418\uc5b4 \ud55c column\uc529 \ubc00\ub9ac\uac70\ub098 \ud55c row\uac00 \uc5ec\ub7ec row\ub85c \uc798\ubabb \uc800\uc7a5\ub418\ub294 \ub4f1\uc758 \uc624\ub958 \ucc98\ub9ac\uac00 \ubc18\ub4dc\uc2dc \ud544\uc694\ud568.<\/li><li>\ucd08\uae30 Tool \uc120\uc815\uc2dc \ub300\uc6a9\ub7c9 \ud14c\uc774\ube14\uc744 \ub300\uc0c1\uc73c\ub85c pilot \ud14c\uc2a4\ud2b8\ub97c \uc9c4\ud589\ud558\uc5ec \uc801\ud569\ud55c Tool\uc744 \uc120\uc815\ud574\uc57c \ud558\uba70, \uc774\uc640 \ud568\uaed8 \uacbd\ud5d8\uc774 \ub9ce\uc740 ETL \uac1c\ubc1c \uc778\ub825 \ud655\ubcf4\uac00 \uc911\uc694\ud568<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6.2._Oracle_Utility_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"62_Oracle_Utility_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>6.2. Oracle Utility \ud65c\uc6a9 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Oracle \uae30\ub2a5\uacfc Utility\ub97c \ud65c\uc6a9\ud558\uc5ec Character Set \ubcc0\ud658\uc744 \uad6c\ud604\ud558\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf8\ub2e4<\/p>\n\n\n\n<p><strong>1. Data Pump Export\/Import \ud65c\uc6a9<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\uac15\uc81c\ub85c Character Set \ubcc0\uacbd: ALTER DATABASE CHARACTER SET INTERNAL<\/li><li>Export\/Import \uc2e4\ud589: Target Character Set\uacfc \ub3d9\uc77c\ud55c NLS_LANG \uc801\uc6a9<\/li><\/ul>\n\n\n\n<p><strong>2. SQL*Loader \ud65c\uc6a9<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Source DB\uc5d0\uc11c Data unload: SQL*Loader \uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ud3ec\ub9f7, PL\/SQL, Pro*C, Java\ub4f1\uc73c\ub85c \uac1c\ubc1c \ud544\uc694<\/li><li>Target DB\uc5d0 SQL*Loader\ub85c \ub370\uc774\ud130 \uc801\uc7ac<\/li><\/ul>\n\n\n\n<p><strong>3. DB Link &amp; CTAS &amp; UTL_RAW \ud65c\uc6a9<\/strong><br>(\ubcc4\ub3c4 \uae00 \ucc38\uc870: <a href=\"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\">Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)<\/a><strong>)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DB Link \uc0dd\uc131: Target\uc5d0\uc11c Source\ub97c \uac00\ub9ac\ud0a4\ub294 DB Link \uc0dd\uc131<\/li><li>View \uc0dd\uc131: Source\uc5d0\uc11c CHAR, VARCHAR2\uceec\ub7fc\uc744 UTL_RAW.CAST_TO_RAW\ub85c \ubcc0\ud658\ud55c View \uc0dd\uc131<\/li><li>CTAS\ub85c&nbsp;\ub370\uc774\ud130&nbsp;\uc801\uc7ac:&nbsp;Target\uc5d0\uc11c&nbsp;DB&nbsp;Link\ub85c&nbsp;CTAS(Create&nbsp;Table&nbsp;As&nbsp;Select)\ub97c&nbsp;\uc2e4\ud589\ud558\uba74\uc11c&nbsp;UTL_RAW.CAST_TO_VARCHAR2\uc640&nbsp;CONVERT&nbsp;\ud568\uc218&nbsp;\uc801\uc6a9<\/li><\/ul>\n\n\n\n<p>\uac01 \ubc29\ubc95\uc758 \uc7a5\uc810\uacfc \ub2e8\uc810\uc5d0 \ub300\ud574 \uc694\uc57d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\ubc29\ubc95<\/strong><\/td><td><strong>\uc7a5\uc810<\/strong><\/td><td><strong>\ub2e8\uc810<\/strong><\/td><\/tr><tr><td>1. Data Pump Export\/Import<\/td><td>&#8211;&nbsp;&nbsp;\ubcd1\ub82c\ucc98\ub9ac \uac00\ub2a5<br>&#8211;&nbsp;&nbsp;\uac1c\ud589\ubb38\uc790,&nbsp;\ud2b9\uc218\ubb38\uc790,&nbsp;\ub110\ubb38\uc790 \ub4f1\uc758 \uc608\uc678\ucc98\ub9ac \ubd88\ud544\uc694<\/td><td>&#8211;&nbsp;&nbsp;\ub370\uc774\ud130&nbsp;unload&nbsp;\uc2dc\uac04 \ud544\uc694<br>&#8211;&nbsp;&nbsp;\uc6d0\ubcf8&nbsp;DB\uac00&nbsp;US7ASCII\uc778 \uacbd\uc6b0<br>&nbsp; . Character Set&nbsp;\ubcc0\uacbd \ud544\uc694&nbsp;(\uc6d0\ubcf8 \ubcf4\uc874 \ud544\uc694)<br>&nbsp; . CLOB type&nbsp;\ub370\uc774\ud130\uc758 \ucd94\uac00\ubcc0\ud658 \ud544\uc694<\/td><\/tr><tr><td>2. SQL*Loader<\/td><td>&#8211;&nbsp;&nbsp;\ubcd1\ub82c\ucc98\ub9ac \uac00\ub2a5<\/td><td>&#8211;&nbsp;&nbsp;Data file\uc744 \uc0dd\uc131(unload)\ud558\ub294 \uae30\ub2a5 \uac1c\ubc1c \ud544\uc694<br>&#8211;&nbsp;&nbsp;unload\/load\uc758&nbsp;File&nbsp;\ucc98\ub9ac\uc2dc \ubc1c\uc0dd\ud558\ub294 \uc608\uc678\/\uc624\ub958\ucc98\ub9ac \ud544\uc694&nbsp;(\uac1c\ud589\ubb38\uc790,&nbsp;\ud2b9\uc218\ubb38\uc790,&nbsp;\ub110\ubb38\uc790 \ub4f1)<br>&#8211;&nbsp;&nbsp;\ub370\uc774\ud130&nbsp;unload&nbsp;\uc2dc\uac04 \ud544\uc694<\/td><\/tr><tr><td>3. DB Link &amp; CTAS &amp;&nbsp;UTL_RAW<\/td><td>&#8211;&nbsp;&nbsp;\ub370\uc774\ud130&nbsp;unload&nbsp;\uc2dc\uac04 \ubd88\ud544\uc694<\/td><td>&#8211;&nbsp;&nbsp;Parallel hint\ub85c \ubcd1\ub82c \ucc98\ub9ac \uc5b4\ub824\uc6c0&nbsp;(\ub370\uc774\ud130 \ubc94\uc704\ub97c \uc9c1\uc811 \ubd84\ud560\ud558\uc5ec \ucc98\ub9ac\ud574\uc57c \ud568)<br>&#8211;&nbsp;&nbsp;2000 byte\ub97c \ucd08\uacfc\ud558\ub294 \ub370\uc774\ud130\uc5d0\ub294 \uc801\uc6a9\ud560 \uc218 \uc5c6\uc74c(RAW type\uc758 \ucd5c\ub300\uae38\uc774\uac00&nbsp;2000 byte\uc784)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\uc774 \ubc29\ubc95\ub4e4\uc744 \uac80\ud1a0\ud558\uba74\uc11c \ub2e4\uc74c\uc758 \uace0\ub824\uc0ac\ud56d\ub3c4 \ud568\uaed8 \uac80\ud1a0\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Data Pump Export\/Import \ubc29\ubc95\uc744 \ud65c\uc6a9\ud558\uc5ec US7ASCII to AL32UTF8\ub85c\uc758 \ubcc0\ud658 \uc2dc, &lt;ALTER DATABASE CHARACTER SET&gt; DDL\ub85c \uc6d0\ubcf8 DB\uc758 Character Set\uc744 \ubcc0\uacbd\ud574\uc57c \ud568<ul><li>\uc6d0\ubcf8 DB\ub97c \uc9c1\uc811 \ubcc0\uacbd\ud558\ub294 \uac83\uc740 \uad8c\uace0\ud558\uc9c0 \uc54a\uc74c. \uc798\ubabb\ub418\ub294 \uacbd\uc6b0 \ub3cc\uc774\ud0a4\uae30\uac00 \ub9e4\uc6b0 \uc5b4\ub824\uc6b8 \uc218 \uc788\uc74c.<\/li><li>\uc7a5\uc560\ubcf5\uad6c\uc6a9 DB\uac00 \uc774\ubbf8 \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4\uba74 \uc774\ub97c \ud65c\uc6a9\ud558\uac70\ub098 \ub610\ub294 \ubcc4\ub3c4 \ubcf5\uc81c DB\ub97c \uad6c\uc131\ud558\uc5ec \ubcc0\uacbd\ud558\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1\ud568<\/li><li>\ub610\ub294 \uc6d0\ubcf8 DB\uc758 \ubc31\uc5c5 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \uc11c\ubc84\uc5d0 \ubcf5\uad6c\ud558\uc5ec \uc774\ub97c \uc774\uc6a9\ud558\ub294 \ubc29\ubc95\ub3c4 \uac00\ub2a5\ud568.<\/li><li>\uc774\uc678\uc5d0\ub3c4 \ubcf5\uc81cDB\ub97c \uad6c\uc131\ud558\ub294 \uc5ec\ub7ec\uac00\uc9c0 \ubc29\ubc95(Disk \ubcf5\uc81c \ub4f1)\uc744 \uac80\ud1a0\ud558\uace0, \ube44\uc6a9\uacfc \uc2dc\uac04\uc744 \uace0\ub824\ud558\uc5ec \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1\ud568.<\/li><li>\ubcf5\uc81c&nbsp;DB\ub97c&nbsp;\uad6c\uc131\ud558\ub294&nbsp;\uac83\uc774&nbsp;\uc5b4\ub824\uc6b8&nbsp;\uacbd\uc6b0,&nbsp;Full&nbsp;backup\uc774\ud6c4&nbsp;\uc9c4\ud589\ud560&nbsp;\uc218&nbsp;\uc788\uc73c\ub098&nbsp;\ubcf5\uad6c&nbsp;\ud544\uc694\uc2dc&nbsp;\ub370\uc774\ud130&nbsp;\uc591\uc5d0&nbsp;\ub530\ub77c&nbsp;\uc11c\ube44\uc2a4&nbsp;Down-Time\uc774&nbsp;\uae38\uc5b4\uc9c8&nbsp;\uc218&nbsp;\uc788\uc74c<\/li><\/ul><\/li><li>\uc11c\ube44\uc2a4 \uc911\uc9c0\uc0c1\ud0dc\uac00 \uc544\ub2cc \uc774\uc0c1 \uc5b4\ub5a4 \ubc29\ubc95\uc744 \uc801\uc6a9\ud558\ub354\ub77c\ub3c4 \ub370\uc774\ud130 \uc815\ud569\uc131 \ud655\ubcf4\ub97c \uc704\ud558\uc5ec \uc6d0\ubcf8 DB\ub85c\ubd80\ud130\uc758 \ucd94\ucd9c\uc2dc\uc810\uc744 \uc77c\uce58\uc2dc\ucf1c\uc57c \ud568(FLASHBACK_SCN, FLASHBACK_TIME \ud65c\uc6a9)<\/li><li>\ub610\ud55c,&nbsp;\ucd94\ucd9c\uc2dc\uc810&nbsp;\uc774\ud6c4\uc758&nbsp;\ubcc0\uacbd&nbsp;\ub370\uc774\ud130&nbsp;\ubc18\uc601&nbsp;\ubc29\ubc95\uc744&nbsp;\ubbf8\ub9ac&nbsp;\ud14c\uc2a4\ud2b8\ud558\uace0&nbsp;\uc900\ube44\ud574\uc57c&nbsp;\ud568&nbsp;(CDC&nbsp;\ud65c\uc6a9&nbsp;\ub4f1)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.2.1._\ubc29\ubc951)_Data_Pump_Export\/Import\"><span class=\"ez-toc-section\" id=\"621_%EB%B0%A9%EB%B2%951_Data_Pump_ExportImport\"><\/span>6.2.1. \ubc29\ubc951)&nbsp;Data&nbsp;Pump&nbsp;Export\/Import<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc900\ube44: \ub2e4\uc74c script\ub85c Data&nbsp;Pump&nbsp;Export\/Import&nbsp;\uc2e4\ud589\uc2dc&nbsp;\ud544\uc694\ud55c&nbsp;Directory \uac1c\uccb4 \uc0dd\uc131\uacfc \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c\ub2e4.&nbsp;<\/p>\n\n\n\n<p>\ud14c\uc2a4\ud2b8 \ub300\uc0c1 Oracle instance\uc778 ORAUS7, ORAMSWIN949, ORAUTF \uac01\uac01\uc5d0 \ub300\ud558\uc5ec \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<p>\u25bc ORAUS7&nbsp;instance\uc5d0&nbsp;\uad8c\ud55c&nbsp;\ubd80\uc5ec<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- ORAUS7 instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAUS7\nset NLS_LANG=AMERICAN_AMERICA.US7ASCII\nsqlplus sys\/________@oraus7 as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>\u25bc ORAMSWIN949 instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- ORAMSWIN949 instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAMSWIN949\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nsqlplus sys\/________@oramswin949 as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>\u25bc ORAUTF instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- ORAUTF instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAUTF\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nsqlplus sys\/________@orautf as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>\ub2e4\uc74c \uc138 \uac00\uc9c0 \uacbd\uc6b0\uc5d0 \ub300\ud558\uc5ec \uac01\uac01 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>KO16MSWIN949&nbsp;to&nbsp;AL32UTF8<\/li><li>US7ASCII&nbsp;to&nbsp;AL32UTF8&nbsp;(2&nbsp;path)<\/li><li>US7ASCII&nbsp;to&nbsp;AL32UTF8&nbsp;(1&nbsp;path)<\/li><\/ol>\n\n\n\n<p>\ucc38\uace0\ub85c, US7ASCII to AL32UTF8 \ubcc0\ud658\uc758 \uacbd\uc6b0\ub294 CLOB type \uceec\ub7fc\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\uc9c0 \uc54a\uc544 \ubcc4\ub3c4 \ucc98\ub9ac\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c \uae00\uc5d0\uc11c \uc124\uba85 \uc608\uc815\uc774\ub2e4.<\/p>\n\n\n\n<p><strong>1.&nbsp;KO16MSWIN949&nbsp;to&nbsp;AL32UTF8<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\"><img loading=\"lazy\" decoding=\"async\" width=\"425\" height=\"256\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\" alt=\"1. KO16MSWIN949 to AL32UTF8 \uac1c\ub150\ub3c4\" class=\"wp-image-11959\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png 425w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-48x29.png 48w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/a><figcaption>1. KO16MSWIN949 to AL32UTF8 \uac1c\ub150\ub3c4<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774 \uacbd\uc6b0\ub294 CHAR, VARCHAR2, CLOB type\uc774 \ubaa8\ub450 \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub41c\ub2e4.<\/p>\n\n\n\n<p>\uac01&nbsp;\ub2e8\uacc4\ubcc4&nbsp;\uc2e4\ud589&nbsp;\uc2a4\ud06c\ub9bd\ud2b8\ub294&nbsp;\ub2e4\uc74c\uacfc&nbsp;\uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=PUMP_DIR dumpfile=oramswin949_leg.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nimpdp leg\/leg@orautf directory=PUMP_DIR dumpfile= oramswin949_leg.dmp logfile=orautf_leg_imp.log content=data_only<\/pre>\n\n\n\n<p><strong>2.&nbsp;US7ASCII&nbsp;to&nbsp;AL32UTF8&nbsp;(2&nbsp;path)<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"377\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png\" alt=\"2. US7ASCII to AL32UTF8 (2 path) \uac1c\ub150\ub3c4\" class=\"wp-image-11960\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png 624w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-48x29.png 48w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>2. US7ASCII to AL32UTF8 (2 path) \uac1c\ub150\ub3c4<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\uc784\uc2dc \ubcf5\uc81c DB\uc11c\ubc84\ub294 As-Is \uc6b4\uc601 DB\ub97c \uc6d0\ubcf8\uacfc \ub3d9\uc77c\ud55c \ud615\ud0dc\ub85c \ubcf5\uc81c\ud55c DB\uc784.<\/li><li>\ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c\ub294 ORAMSWIN949 instance\ub97c \uc784\uc2dc \ubcf5\uc81c DB\ub85c \uc0ac\uc6a9\ud588\uace0, Data Pump\ub85c \ub370\uc774\ud130\ub97c \ubcf5\uc81c\ud558\ub294\ub370, \uc774 \uacbd\uc6b0 \ubcf5\uc81c\ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac Character Set\uc744 US7ASCII\ub85c \ubcc0\uacbd\ud574 \ub450\uc5b4\uc57c \ud568<\/li><li>\uc2e4 \uc801\uc6a9\uc2dc\ub294 \uc784\uc2dc \ubcf5\uc81c DB\uc11c\ubc84\ub97c US7ASCII Character Set\uc73c\ub85c \ubcc4\ub3c4 \uad6c\uc131\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1\ud568.<\/li><\/ul>\n\n\n\n<p>\uc774 \ubc29\ubc95\uc740 ORACLE\uc5d0\uc11c \uad8c\uc7a5\ud558\ub294 \ubc29\ubc95\uc774 \uc544\ub2c8\uace0 CLOB&nbsp;type\uc758&nbsp;\ub370\uc774\ud130\ub294&nbsp;\uc815\uc0c1&nbsp;\ubcc0\ud658\ub418\uc9c0&nbsp;\uc54a\uae30&nbsp;\ub54c\ubb38\uc5d0 \ubcc4\ub3c4&nbsp;\ubcc0\ud658&nbsp;\ucc98\ub9ac\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p>\uac01 \ub2e8\uacc4\ubcc4 \uc2e4\ud589 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41-1\n-- \uc2e4\ud589 Instance: ORAUS7\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\nset NLS_LANG=US7ASCII\nexpdp leg\/leg@oraus7 directory=MIG_DIR dumpfile=oraus7_leg_exp.dmp logfile=oraus7_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc41-2\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nset NLS_LANG=US7ASCII\nimpdp leg\/leg@oramswin949 directory= MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Character Set \ubcc0\uacbd\n-- Tool: SQL*Plus\nSHUTDOWN IMMEDIATE;\nSTARTUP MOUNT;\nALTER SYSTEM ENABLE RESTRICTED SESSION;\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\nALTER DATABASE OPEN;\nALTER DATABASE CHARACTER SET INTERNAL_USE KO16MSWIN949;\nSHUTDOWN IMMEDIATE;\nSTARTUP;\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n-- sql*plus\uc5d0\uc11c \ud55c\uae00 \ud45c\uc2dc \ub418\ub294\uc9c0 \ud655\uc778 \ud6c4 \ub2e4\uc74c \uc2e4\ud589\nset NLS_LANG=KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc44\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc45\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nimpdp leg\/leg@orautf directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log content=data_only<\/pre>\n\n\n\n<p><strong>3.&nbsp;US7ASCII&nbsp;to&nbsp;AL32UTF8&nbsp;(1&nbsp;path)<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png\"><img loading=\"lazy\" decoding=\"async\" width=\"426\" height=\"404\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png\" alt=\"3. US7ASCII to AL32UTF8 (1 path) \uac1c\ub150\ub3c4\" class=\"wp-image-11961\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png 426w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-300x285.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-36x34.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-48x46.png 48w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/a><figcaption>3. US7ASCII to AL32UTF8 (1 path) \uac1c\ub150\ub3c4<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774&nbsp;\ubc29\ubc95\uc740&nbsp;ORACLE\uc5d0\uc11c&nbsp;\uad8c\uc7a5\ud558\ub294&nbsp;\ubc29\ubc95\uc774&nbsp;\uc544\ub2c8\uace0&nbsp;CLOB&nbsp;type\uc758&nbsp;\ub370\uc774\ud130\ub294&nbsp;\uc815\uc0c1&nbsp;\ubcc0\ud658\ub418\uc9c0&nbsp;\uc54a\uae30&nbsp;\ub54c\ubb38\uc5d0&nbsp;\ubcc4\ub3c4&nbsp;\ubcc0\ud658&nbsp;\ucc98\ub9ac\uac00&nbsp;\ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p>\ub610\ud55c, \uc6b4\uc601 DB\uc758 Character Set\uc744 \ubcc0\uacbd\ud558\ubbc0\ub85c \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \ubcf4\uc874\ud560 \uc218 \uc5c6\uc5b4\uc11c \uc798\ubabb\ub418\ub294 \uacbd\uc6b0\uc5d0 Roll-back\uc774 \uc5b4\ub824\uc6b0\ub2c8, \uac00\uae09\uc801 \uc6b4\uc601\ud658\uacbd\uc5d0 \uc801\uc6a9\ud558\uc9c0 \uc54a\uc544\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p>\ubd80\ub4dd\uc774\ud558\uac8c \uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c \ucda9\ubd84\ud788 \uac80\uc99d\ud6c4 \uc6b4\uc601\ud658\uacbd\uc5d0 \uc801\uc6a9\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p>\uac01&nbsp;\ub2e8\uacc4\ubcc4&nbsp;\uc2e4\ud589&nbsp;\uc2a4\ud06c\ub9bd\ud2b8\ub294&nbsp;\ub2e4\uc74c\uacfc&nbsp;\uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41\n-- \uc2e4\ud589 Instance: ORAUS7\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Character Set \ubcc0\uacbd\n-- Tool: SQL*Plus\nSHUTDOWN IMMEDIATE;\nSTARTUP MOUNT;\nALTER SYSTEM ENABLE RESTRICTED SESSION;\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\nALTER DATABASE OPEN;\nALTER DATABASE CHARACTER SET INTERNAL_USE KO16MSWIN949;\nSHUTDOWN IMMEDIATE;\nSTARTUP;\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAMSWIN949(=ORAUS7)\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n-- sql*plus\uc5d0\uc11c \ud55c\uae00 \ud45c\uc2dc \ub418\ub294\uc9c0 \ud655\uc778 \ud6c4 \ub2e4\uc74c \uc2e4\ud589\nset NLS_LANG=KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc44\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nimpdp leg\/leg@orautf directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log content=data_only<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.2.2._\ubc29\ubc952)_SQL*Loader\"><span class=\"ez-toc-section\" id=\"622_%EB%B0%A9%EB%B2%952_SQLLoader\"><\/span>6.2.2. \ubc29\ubc952) SQL*Loader<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>SQL*Loader\ub294 control file\uacfc data file\uc774 \ud544\uc694\ud558\ub2e4. \uc774 \uc911\uc5d0\uc11c data file\uc774 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud55c\ub2e4.<\/p>\n\n\n\n<p>\uc774 data file\uc744 \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc740 PL\/SQL, Pro*C, Java \ub4f1 \uc5ec\ub7ec Tool\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc9c1\uc811 \ub9cc\ub4e4\uac70\ub098, \ub3d9\uc77c\ud55c \uae30\ub2a5\uc744 \uc774\ubbf8 \uad6c\ud604\ud574 \ub193\uc740 \uc18c\uc2a4\ucf54\ub4dc\ub97c \ucc38\uc870\ud558\uc5ec \uadf8\ub300\ub85c \uc4f0\uac70\ub098 \uc57d\uac04 \ud655\uc7a5\ud558\ub294 \ubc29\ubc95\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc5ec\uae30\uc11c\ub294 \uc9c1\uc811 \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc740 \uc18c\uac1c\ud558\uc9c0 \uc54a\uace0, \uad6c\ud604\ud574 \ub193\uc740 \uc18c\uc2a4\ucf54\ub4dc\uc758 URL\ub9cc \uc18c\uac1c\ud55c\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\" style=\"font-size:17px\"><p>Effective Oracle\uc758 \uc800\uc790\uc778 Tom Kyte \ube14\ub85c\uadf8: <a href=\"https:\/\/asktom.oracle.com\/Misc\/httpasktomoraclecomtkyteflat.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/asktom.oracle.com\/Misc\/httpasktomoraclecomtkyteflat.html<\/a><\/p><\/blockquote>\n\n\n\n<p>\uc774\uc678\uc5d0\ub3c4,&nbsp;\uad6c\uae00\uc5d0\uc11c&nbsp;\uac80\uc0c9\ud558\uba74&nbsp;\ucc38\uc870\ud560&nbsp;\uc218&nbsp;\uc788\ub294&nbsp;\uc18c\uc2a4\ucf54\ub4dc\ub97c&nbsp;\uad6c\ud560&nbsp;\uc218&nbsp;\uc788\uc744&nbsp;\uac83\uc774\ub2e4.<\/p>\n\n\n\n<p>\ud14c\uc774\ube14 \ub2e8\uc704\ub098 \ud30c\ud2f0\uc158 \ub2e8\uc704\ub85c data file\uc744 \uc0dd\uc131\ud55c \ub2e4\uc74c, sqlldr\ub97c \ub2e4\uc218\uc758 \uadf8\ub8f9\uc73c\ub85c \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud558\uc5ec \ubcd1\ub82c\ub85c \uc801\uc7ac\ud558\uc5ec \uc801\uc815 \uc218\uc900\uc758 \ubd80\ud558\ub85c \uc2e4\ud589\uc2dc\uac04\uc744 \ucd5c\uc18c\ud654\ud560 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ubcc4\ub3c4 \uad6c\ud604\uc774 \ud544\uc694\ud55c \ubc29\ubc95\uc740 Oracle\uc5d0\uc11c \ubcc0\ud658\uc744 \ubcf4\uc7a5\ud558\uc9c0 \uc54a\uace0 \uad6c\ud604\ud55c \uc0ac\uc6a9\uc790\uac00 \ubcc0\ud658\uc744 \ubcf4\uc7a5\ud574\uc57c \ud558\ubbc0\ub85c \uae30\uc220 \uac80\uc99d\uacfc \ub2e4\uc591\ud55c&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":11959,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249,254,255,256,257,258,259],"class_list":["post-11958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949","tag-data-pump","tag-export","tag-import","tag-al32utf8"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T06:10:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:09:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\" \/>\n\t<meta property=\"og:image:width\" content=\"425\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)\",\"datePublished\":\"2022-10-03T06:10:08+00:00\",\"dateModified\":\"2022-10-04T15:09:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/\"},\"wordCount\":561,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-86.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"Data Pump\",\"Export\",\"Import\",\"AL32UTF8\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-86.png\",\"datePublished\":\"2022-10-03T06:10:08+00:00\",\"dateModified\":\"2022-10-04T15:09:13+00:00\",\"description\":\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-86.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-86.png\",\"width\":425,\"height\":256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-8-datapump-export-import\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill","description":"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/","og_locale":"ko_KR","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-8-datapump-export-import\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T06:10:08+00:00","article_modified_time":"2022-10-04T15:09:13+00:00","og_image":[{"width":425,"height":256,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"Zerom","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"9\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)","datePublished":"2022-10-03T06:10:08+00:00","dateModified":"2022-10-04T15:09:13+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"},"wordCount":561,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","Data Pump","Export","Import","AL32UTF8"],"articleSection":["ORACLE"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/","name":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","datePublished":"2022-10-03T06:10:08+00:00","dateModified":"2022-10-04T15:09:13+00:00","description":"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","width":425,"height":256},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\uc0dd\uc0b0\uc131 Skill","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/ko\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/comments?post=11958"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11958\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media\/11959"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media?parent=11958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/categories?post=11958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/tags?post=11958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}