{"id":11936,"date":"2022-10-03T11:06:42","date_gmt":"2022-10-03T02:06:42","guid":{"rendered":"https:\/\/prodskill.com\/?p=11936"},"modified":"2022-10-05T00:03:29","modified_gmt":"2022-10-04T15:03:29","slug":"oracle-character-set-migration-4-test-environment","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-4-test-environment\/","title":{"rendered":"Oracle Character Set Conversion (4): 4.Configuring the Test Environment"},"content":{"rendered":"<p>Continuing from the previous article, we look at the configuration of the Oracle Character Set conversion test environment. You can check Oracle server environment configuration (three instances, DB Link creation), test table creation, and test data creation scripts. This test environment is used in the character set conversion process later.<\/p>\n\n\n\n<p>This is a continuation of the previous article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-3-client-env-config-2\/\">Oracle Character Set Conversion (3): 3. Client Environment Configuration (2)<\/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;Table of Contents&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=\"Toggle Table of Content\"><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\/en\/oracle-character-set-migration-4-test-environment\/#4_Oracle_Character_Set_%EB%B3%80%ED%99%98_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\" >4. Configure Oracle Character Set Conversion Test Environment<\/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\/en\/oracle-character-set-migration-4-test-environment\/#41_Oracle_DB_%EC%84%9C%EB%B2%84_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\" >4.1. Oracle DB Server Environment Configuration<\/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\/en\/oracle-character-set-migration-4-test-environment\/#42_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%85%8C%EC%9D%B4%EB%B8%94_%EA%B5%AC%EC%84%B1\" >4.2. test table configuration<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"4._Oracle_Character_Set_\ubcc0\ud658_\ud14c\uc2a4\ud2b8_\ud658\uacbd_\uad6c\uc131\"><span class=\"ez-toc-section\" id=\"4_Oracle_Character_Set_%EB%B3%80%ED%99%98_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\"><\/span>4. Configure Oracle Character Set Conversion Test Environment<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.1._DB_\uc11c\ubc84_\ud658\uacbd_\uad6c\uc131\"><span class=\"ez-toc-section\" id=\"41_Oracle_DB_%EC%84%9C%EB%B2%84_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\"><\/span>4.1. Oracle DB Server Environment Configuration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is assumed that the test environment for Oracle Character Set conversion is configured as follows on the Local PC (Windows).<\/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-83.png\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"333\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83.png\" alt=\"Oracle DB \uc11c\ubc84 \ud658\uacbd \uad6c\uc131\" class=\"wp-image-11937\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83.png 940w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-300x106.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-768x272.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-36x13.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-83-48x17.png 48w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><figcaption>Oracle DB server environment configuration<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Three Oracle DB instances were installed on one PC, and the configuration of each is as follows.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Environment<\/strong><\/td><td><strong>SID<\/strong><\/td><td><strong>Server Character Set<\/strong><\/td><td><strong>Oracle Version<\/strong><\/td><td><strong>Test User (Schema)<\/strong><\/td><\/tr><tr><td>US7ASCII Current DB<\/td><td>ORAUS7<\/td><td>US7ASCII<\/td><td>11.2.0.1.0<\/td><td>LEG<\/td><\/tr><tr><td>KO16MSWIN949 Current DB<\/td><td>ORAMSWIN949<\/td><td>KO16MSWIN949<\/td><td>11.2.0.1.0<\/td><td>LEG<\/td><\/tr><tr><td>AL32UTF8 Target DB<\/td><td>ORAUTF<\/td><td>AL32UTF8<\/td><td>11.2.0.1.0<\/td><td>LEG<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>DB Link is configured as follows.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Generated SID<\/strong><\/td><td><strong>Target SID<\/strong><\/td><td><strong>Connection User (Schema)<\/strong><\/td><td><strong>purpose<\/strong><\/td><\/tr><tr><td>ORAMSWIN949<\/td><td>ORAUS7<\/td><td>LEG<\/td><td>US7ASCII access and conversion test on KO16MSWIN949<\/td><\/tr><tr><td>ORAUTF<\/td><td>ORAUS7<\/td><td>LEG<\/td><td>AL32UTF8 to US7ASCII access and conversion test<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The DB Link creation script is as follows.<\/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=\"\" data-no-auto-translation=\"\">CREATE DATABASE LINK DL_US7\nCONNECT TO leg IDENTIFIED BY leg\nUSING '(DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = ORAUS7)\n    )\n  )'\n;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.2._\ud14c\uc2a4\ud2b8_\ud14c\uc774\ube14_\uad6c\uc131\"><span class=\"ez-toc-section\" id=\"42_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%85%8C%EC%9D%B4%EB%B8%94_%EA%B5%AC%EC%84%B1\"><\/span>4.2. test table configuration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The data model for testing is as follows.<\/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-84.png\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"253\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png\" alt=\"Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uad6c\uc131\" class=\"wp-image-11938\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png 894w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-300x85.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-768x217.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-48x14.png 48w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/a><figcaption>Oracle Character Set Conversion Test Table Configuration<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(For testing purposes, all additional details such as normalization and identifier configuration are omitted. The same length is applied to US7ASCII and MSWIN949, and the length is increased to AL32UTF8.)<\/p>\n\n\n\n<p>The data model above is a structure in which two items (reference description, reference image) for testing are added to the data set of &lt;Information on the number of people getting on and off by subway line and station in Seoul&gt; disclosed by the Seoul Metropolitan Government.<\/p>\n\n\n\n<p>source:&nbsp;<a href=\"https:\/\/data.seoul.go.kr\/dataList\/OA-12252\/S\/1\/datasetView.do\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/data.seoul.go.kr\/dataList\/OA-12252\/S\/1\/datasetView.do<\/a><\/p>\n\n\n\n<p>The DDL that creates the schema of the test data model above is as follows.<\/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=\"\" data-no-auto-translation=\"\">-- \ud55c\uae00 2 byte \uccb4\uacc4 \uc2a4\ud0a4\ub9c8 \uc0dd\uc131(US7ASCII, MSWIN949)\nCREATE TABLE SUB_MON_STAT \n(\n      USE_MON            VARCHAR2(8),\n      LINE_NUM           VARCHAR2(14), -- AL32UTF8: 50\n      SUB_STA_ID         VARCHAR2(4),\n      SUB_STA_NM         VARCHAR2(20), -- AL32UTF8: 100\n      RIDE_PASGR_NUM     NUMBER(10),\n      ALIGHT_PASGR_NUM   NUMBER(10),\n      WORK_DT            VARCHAR2(8),\n      COMMT              VARCHAR2(4000),\n      REF_DES            CLOB,\n      REF_IMG            BLOB\n);\n\n-- \ud55c\uae00 3 byte \uccb4\uacc4 \uc2a4\ud0a4\ub9c8 \uc0dd\uc131(AL32UTF8)\nCREATE TABLE SUB_MON_STAT \n(\n      USE_MON            VARCHAR2(8),\n      LINE_NUM           VARCHAR2(50),\n      SUB_STA_ID         VARCHAR2(4),\n      SUB_STA_NM         VARCHAR2(100),\n      RIDE_PASGR_NUM     NUMBER(10),\n      ALIGHT_PASGR_NUM   NUMBER(10),\n      WORK_DT            VARCHAR2(8),\n      COMMT              VARCHAR2(4000),\n      REF_DES            CLOB,\n      REF_IMG            BLOB\n);<\/pre>\n\n\n\n<p>In AL32UTF8, 3 bytes are required for 1 Korean character, so the length of the two columns is increased sufficiently.<\/p>\n\n\n\n<p>Data files in Excel format can be downloaded from the github path below.<\/p>\n\n\n\n<p>* Excel data file:&nbsp;<a href=\"https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/raw\/main\/%EC%A7%80%ED%95%98%EC%B2%A0%EC%97%AD%EB%B3%84%20%EC%8A%B9%ED%95%98%EC%B0%A8%EC%9D%B8%EC%9B%90_%EC%84%9C%EC%9A%B8%EC%8B%9C%EC%98%A4%ED%94%88%EB%8D%B0%EC%9D%B4%ED%84%B0_2013.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/raw\/main\/Number of passengers by subway station_Seoul Open Data_2013.xlsx<\/a><\/p>\n\n\n\n<p>The DML for entering data into the table can be downloaded from the github path below.<\/p>\n\n\n\n<p>* DML:&nbsp;<a href=\"https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/raw\/main\/%EC%A7%80%ED%95%98%EC%B2%A0%EC%97%AD%EB%B3%84%20%EC%8A%B9%ED%95%98%EC%B0%A8%EC%9D%B8%EC%9B%90_%EC%84%9C%EC%9A%B8%EC%8B%9C%EC%98%A4%ED%94%88%EB%8D%B0%EC%9D%B4%ED%84%B0_2013.sql\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/raw\/main\/Number of passengers by subway station_Seoul Open Data_2013.sql<\/a><\/p>\n\n\n\n<p>Some excerpts from the above sql file are pasted below.<\/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=\"\" data-no-auto-translation=\"\">INSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT, COMMT, REF_DES, REF_IMG)\nVALUES('201301', '1\ud638\uc120', '0150', '\uc11c\uc6b8\uc5ed', 2199181, 1855268, '20130723', RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'), RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'), UTL_RAW.CAST_TO_RAW('12345'));\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0151', '\uc2dc\uccad', 737005, 726892, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0152', '\uc885\uac01', 1542710, 1446464, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0153', '\uc885\ub85c3\uac00', 1159253, 1126995, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0154', '\uc885\ub85c5\uac00', 816307, 820769, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0155', '\ub3d9\ub300\ubb38', 446527, 512163, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0156', '\uc2e0\uc124\ub3d9', 496150, 484583, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0157', '\uc81c\uae30\ub3d9', 587740, 601913, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0158', '\uccad\ub7c9\ub9ac(\uc9c0\ud558)', 966341, 985741, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '1\ud638\uc120', '0159', '\ub3d9\ubb18\uc55e', 240864, 252523, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0202', '\uc744\uc9c0\ub85c\uc785\uad6c', 1610744, 1607133, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0203', '\uc744\uc9c0\ub85c3\uac00', 539622, 559866, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0204', '\uc744\uc9c0\ub85c4\uac00', 364217, 365994, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0205', '\ub3d9\ub300\ubb38\uc5ed\uc0ac\ubb38\ud654\uacf5\uc6d0', 435358, 508405, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0206', '\uc2e0\ub2f9', 407110, 438543, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0207', '\uc0c1\uc655\uc2ed\ub9ac', 288629, 274519, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0208', '\uc655\uc2ed\ub9ac', 583444, 498091, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0209', '\ud55c\uc591\ub300', 262492, 286399, '20130723');\n\nINSERT INTO SUB_MON_STAT(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM, ALIGHT_PASGR_NUM, WORK_DT)\nVALUES('201301', '2\ud638\uc120', '0210', '\ub69d\uc12c', 402631, 420166, '20130723');\n\n...<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>So far, we have looked at test environment configuration and configuration scripts for Oracle Character Set conversion. Next, we&#039;ll look at different ways to transform the Character Set in this test environment. We will look into the method recommended by Oracle and the method that requires a separate implementation.<\/p>","protected":false},"excerpt":{"rendered":"<p>Continuing from the previous article, we look at the configuration of the Oracle Character Set conversion test environment. You can check Oracle server environment configuration (three instances, DB Link creation), test table creation, and test data creation scripts. This test environment was later used in the character set conversion process...<\/p>","protected":false},"author":1,"featured_media":11938,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249,251],"class_list":["post-11936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-251"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc55e \uae00\uc5d0 \uc774\uc5b4\uc11c Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle \uc11c\ubc84 \ud658\uacbd \uad6c\uc131(\uc138 \uac1c instance, DB Link \uc0dd\uc131), \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131, \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \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\/en\/oracle-character-set-migration-4-test-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc55e \uae00\uc5d0 \uc774\uc5b4\uc11c Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle \uc11c\ubc84 \ud658\uacbd \uad6c\uc131(\uc138 \uac1c instance, DB Link \uc0dd\uc131), \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131, \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-4-test-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T02:06:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:03:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png\" \/>\n\t<meta property=\"og:image:width\" content=\"894\" \/>\n\t<meta property=\"og:image:height\" content=\"253\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\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-4-test-environment\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131\",\"datePublished\":\"2022-10-03T02:06:42+00:00\",\"dateModified\":\"2022-10-04T15:03:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/\"},\"wordCount\":225,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-84.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-84.png\",\"datePublished\":\"2022-10-03T02:06:42+00:00\",\"dateModified\":\"2022-10-04T15:03:29+00:00\",\"description\":\"\uc55e \uae00\uc5d0 \uc774\uc5b4\uc11c Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle \uc11c\ubc84 \ud658\uacbd \uad6c\uc131(\uc138 \uac1c instance, DB Link \uc0dd\uc131), \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131, \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-84.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-84.png\",\"width\":894,\"height\":253},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-4-test-environment\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131\"}]},{\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set Conversion (4): 4. Test Environment Configuration - Productivity Skill","description":"Continuing from the previous article, we&#039;ll examine the Oracle Character Set conversion test environment configuration. You&#039;ll find scripts for configuring the Oracle server environment (three instances, creating a DB Link), creating test tables, and creating test data.","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\/en\/oracle-character-set-migration-4-test-environment\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc55e \uae00\uc5d0 \uc774\uc5b4\uc11c Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle \uc11c\ubc84 \ud658\uacbd \uad6c\uc131(\uc138 \uac1c instance, DB Link \uc0dd\uc131), \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131, \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-4-test-environment\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T02:06:42+00:00","article_modified_time":"2022-10-04T15:03:29+00:00","og_image":[{"width":894,"height":253,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131","datePublished":"2022-10-03T02:06:42+00:00","dateModified":"2022-10-04T15:03:29+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/"},"wordCount":225,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/","name":"Oracle Character Set Conversion (4): 4. Test Environment Configuration - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png","datePublished":"2022-10-03T02:06:42+00:00","dateModified":"2022-10-04T15:03:29+00:00","description":"Continuing from the previous article, we&#039;ll examine the Oracle Character Set conversion test environment configuration. You&#039;ll find scripts for configuring the Oracle server environment (three instances, creating a DB Link), creating test tables, and creating test data.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png","width":894,"height":253},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11936"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11938"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}