{"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\/de\/oracle-character-set-migration-4-test-environment\/","title":{"rendered":"Oracle-Zeichensatzkonvertierung (4): 4.Konfigurieren der Testumgebung"},"content":{"rendered":"<p>Als Fortsetzung des vorherigen Artikels werden wir uns die Konfiguration der Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung ansehen. Sie k\u00f6nnen die Konfiguration der Oracle-Serverumgebung (drei Instanzen, DB-Link-Erstellung), die Testtabellenerstellung und das Testdatenerstellungsskript \u00fcberpr\u00fcfen. Diese Testumgebung wird sp\u00e4ter bei der Zeichensatzkonvertierung verwendet.<\/p>\n\n\n\n<p>Dies ist eine Fortsetzung des vorherigen Artikels.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/de\/oracle-character-set-migration-3-client-env-config-2\/\">Oracle-Zeichensatzkonvertierung (3): 3. Konfiguration der Client-Umgebung (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;Inhaltsverzeichnis&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=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/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\/de\/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. Konfigurieren Sie die Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung<\/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\/de\/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. Konfiguration der Oracle DB-Serverumgebung<\/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\/de\/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. Testtabellenkonfiguration<\/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. Konfigurieren Sie die Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung<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. Konfiguration der Oracle DB-Serverumgebung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gehen Sie davon aus, dass die Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung auf einem lokalen PC (Windows) wie folgt konfiguriert ist.<\/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>Konfiguration der Oracle DB-Serverumgebung<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Auf einem PC wurden drei Oracle DB-Instanzen installiert, und jede Konfiguration ist wie folgt.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Umfeld<\/strong><\/td><td><strong>SID<\/strong><\/td><td><strong>Server-Zeichensatz<\/strong><\/td><td><strong>Oracle-Version<\/strong><\/td><td><strong>Testbenutzer (Schema)<\/strong><\/td><\/tr><tr><td>US7ASCII Aktueller DB<\/td><td>ORAUS7<\/td><td>US7ASCII<\/td><td>11.2.0.1.0<\/td><td>BEIN<\/td><\/tr><tr><td>KO16MSWIN949 Aktueller DB<\/td><td>ORAMSWIN949<\/td><td>KO16MSWIN949<\/td><td>11.2.0.1.0<\/td><td>BEIN<\/td><\/tr><tr><td>AL32UTF8 Ziel-DB<\/td><td>ORAUTF<\/td><td>AL32UTF8<\/td><td>11.2.0.1.0<\/td><td>BEIN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>DB Link ist wie folgt konfiguriert.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>SID generieren<\/strong><\/td><td><strong>Ziel-SID<\/strong><\/td><td><strong>Verbindungsbenutzer (Schema)<\/strong><\/td><td><strong>Zweck<\/strong><\/td><\/tr><tr><td>ORAMSWIN949<\/td><td>ORAUS7<\/td><td>BEIN<\/td><td>US7ASCII-Zugriffs- und Konvertierungstest auf KO16MSWIN949<\/td><\/tr><tr><td>ORAUTF<\/td><td>ORAUS7<\/td><td>BEIN<\/td><td>Zugriffs- und Konvertierungstest von AL32UTF8 zu US7ASCII<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Das DB-Link-Erstellungsskript lautet wie folgt.<\/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. Testtabellenkonfiguration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Das Datenmodell zum Testen ist wie folgt.<\/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>Konfiguration der Oracle-Zeichensatzkonvertierungstesttabelle<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(Zu Testzwecken wurden alle zus\u00e4tzlichen Details wie Normalisierung und Bezeichnerkonfiguration weggelassen. US7ASCII und MSWIN949 wenden dieselbe L\u00e4nge an, und AL32UTF8 erh\u00f6ht die L\u00e4nge.)<\/p>\n\n\n\n<p>Das obige Datenmodell ist eine Struktur, die den von der Seoul Metropolitan Government ver\u00f6ffentlichten &lt;Informationen zur Anzahl der Personen, die in jede U-Bahn-Linie und Station in Seoul ein- und aussteigen&gt;, zwei Elemente (Referenzbeschreibung, Referenzbild) zum Testen hinzuf\u00fcgt.<\/p>\n\n\n\n<p>Quelle:&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>Die DDL, die das Schema des obigen Testdatenmodells erstellt, lautet wie folgt.<\/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 ben\u00f6tigt ein koreanisches Zeichen 3 Bytes, daher wurde die L\u00e4nge der beiden Spalten ausreichend vergr\u00f6\u00dfert.<\/p>\n\n\n\n<p>Datendateien im Excel-Format k\u00f6nnen \u00fcber den unten stehenden Github-Pfad heruntergeladen werden.<\/p>\n\n\n\n<p>* Excel-Datendatei:&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\/Anzahl der Passagiere pro U-Bahn-Station_Seoul Open Data_2013.xlsx<\/a><\/p>\n\n\n\n<p>DML zum Eingeben von Daten in die Tabelle kann vom folgenden Github-Pfad heruntergeladen werden.<\/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\/Anzahl der Passagiere pro U-Bahn-Station_Seoul Open Data_2013.sql<\/a><\/p>\n\n\n\n<p>Ein Teil der obigen SQL-Datei ist ein Auszug und wird unten eingef\u00fcgt.<\/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>Bisher haben wir uns die Konfiguration der Testumgebung und das Konfigurationsskript f\u00fcr die Konvertierung von Oracle-Zeichens\u00e4tzen angesehen. Als n\u00e4chstes werden wir uns verschiedene M\u00f6glichkeiten ansehen, den Zeichensatz in dieser Testumgebung zu konvertieren. Wir werden uns die von Oracle empfohlenen Methoden und Methoden ansehen, die eine separate Implementierung erfordern.<\/p>","protected":false},"excerpt":{"rendered":"<p>Als Fortsetzung des vorherigen Artikels werden wir uns die Konfiguration der Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung ansehen. Sie k\u00f6nnen die Konfiguration der Oracle-Serverumgebung (drei Instanzen, DB-Link-Erstellung), die Tabellenerstellung und die Skripts zur Testdatenerstellung \u00fcberpr\u00fcfen. Diese Testumgebung wird sp\u00e4ter im Prozess der Zeichensatzkonvertierung verwendet...<\/p>","protected":false},"author":1,"featured_media":11938,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[251,242,248,249],"class_list":["post-11936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-251","tag-oracle","tag-character-set-","tag-character-set-conversion"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - 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\/de\/oracle-character-set-migration-4-test-environment\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u00a0Minuten\" \/>\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\":[\"\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131\",\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"de\",\"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\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\/de\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle-Zeichensatzkonvertierung (4): 4. Testumgebungskonfiguration \u2013 Produktivit\u00e4tskompetenz","description":"In Fortsetzung des vorherigen Artikels untersuchen wir die Konfiguration der Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung. Sie finden Skripte zum Konfigurieren der Oracle-Serverumgebung (drei Instanzen, Erstellen eines DB-Links), zum Erstellen von Testtabellen und zum Erstellen von Testdaten.","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\/de\/oracle-character-set-migration-4-test-environment\/","og_locale":"de_DE","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\/de\/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":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"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":["\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131","ORACLE","Character Set \ubcc0\ud658","Character Set Conversion"],"articleSection":["ORACLE"],"inLanguage":"de","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-Zeichensatzkonvertierung (4): 4. Testumgebungskonfiguration \u2013 Produktivit\u00e4tskompetenz","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":"In Fortsetzung des vorherigen Artikels untersuchen wir die Konfiguration der Testumgebung f\u00fcr die Oracle-Zeichensatzkonvertierung. Sie finden Skripte zum Konfigurieren der Oracle-Serverumgebung (drei Instanzen, Erstellen eines DB-Links), zum Erstellen von Testtabellen und zum Erstellen von Testdaten.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/"]}]},{"@type":"ImageObject","inLanguage":"de","@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":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11936"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11938"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}