{"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\/es\/oracle-character-set-migration-4-test-environment\/","title":{"rendered":"Conversi\u00f3n de juegos de caracteres de Oracle (4): 4.Configuraci\u00f3n del entorno de prueba"},"content":{"rendered":"<p>Continuando con el art\u00edculo anterior, analizamos la configuraci\u00f3n del entorno de prueba de conversi\u00f3n del juego de caracteres de Oracle. Puede verificar la configuraci\u00f3n del entorno del servidor Oracle (tres instancias, creaci\u00f3n de DB Link), creaci\u00f3n de tablas de prueba y scripts de creaci\u00f3n de datos de prueba. Este entorno de prueba se utiliza en el proceso de conversi\u00f3n de juegos de caracteres m\u00e1s adelante.<\/p>\n\n\n\n<p>Esta es una continuaci\u00f3n del art\u00edculo anterior.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-3-client-env-config-2\/\">Conversi\u00f3n de juego de caracteres de Oracle (3): 3. Configuraci\u00f3n del entorno del cliente (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;Tabla de contenidos&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=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/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\/es\/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. Configurar el entorno de prueba de conversi\u00f3n de juegos de caracteres de Oracle<\/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\/es\/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. Configuraci\u00f3n del entorno del servidor Oracle DB<\/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\/es\/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. configuraci\u00f3n de la mesa de prueba<\/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. Configurar el entorno de prueba de conversi\u00f3n de juegos de caracteres de Oracle<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. Configuraci\u00f3n del entorno del servidor Oracle DB<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Se supone que el entorno de prueba para la conversi\u00f3n del juego de caracteres de Oracle est\u00e1 configurado de la siguiente manera en la PC local (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>Configuraci\u00f3n del entorno del servidor Oracle DB<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Se instalaron tres instancias de Oracle DB en una PC y la configuraci\u00f3n de cada una es la siguiente.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Medioambiente<\/strong><\/td><td><strong>S.I.D.<\/strong><\/td><td><strong>Conjunto de caracteres del servidor<\/strong><\/td><td><strong>Versi\u00f3n de or\u00e1culo<\/strong><\/td><td><strong>Usuario de prueba (esquema)<\/strong><\/td><\/tr><tr><td>US7ASCII base de datos actual<\/td><td>ORAUS7<\/td><td>US7ASCII<\/td><td>11.2.0.1.0<\/td><td>PIERNA<\/td><\/tr><tr><td>KO16MSWIN949 Base de datos actual<\/td><td>ORAMSWIN949<\/td><td>KO16MSWIN949<\/td><td>11.2.0.1.0<\/td><td>PIERNA<\/td><\/tr><tr><td>Base de datos de destino AL32UTF8<\/td><td>ORAUTF<\/td><td>AL32UTF8<\/td><td>11.2.0.1.0<\/td><td>PIERNA<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>DB Link est\u00e1 configurado de la siguiente manera.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>SID generado<\/strong><\/td><td><strong>SID objetivo<\/strong><\/td><td><strong>Usuario de conexi\u00f3n (esquema)<\/strong><\/td><td><strong>prop\u00f3sito<\/strong><\/td><\/tr><tr><td>ORAMSWIN949<\/td><td>ORAUS7<\/td><td>PIERNA<\/td><td>Prueba de acceso y conversi\u00f3n US7ASCII en KO16MSWIN949<\/td><\/tr><tr><td>ORAUTF<\/td><td>ORAUS7<\/td><td>PIERNA<\/td><td>Prueba de conversi\u00f3n y acceso AL32UTF8 a US7ASCII<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>El script de creaci\u00f3n de DB Link es el siguiente.<\/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. configuraci\u00f3n de la mesa de prueba<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>El modelo de datos para la prueba es el siguiente.<\/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>Configuraci\u00f3n de la tabla de prueba de conversi\u00f3n de juegos de caracteres de Oracle<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(Para fines de prueba, se omiten todos los detalles adicionales, como la normalizaci\u00f3n y la configuraci\u00f3n del identificador. Se aplica la misma longitud a US7ASCII y MSWIN949, y se aumenta la longitud a AL32UTF8).<\/p>\n\n\n\n<p>El modelo de datos anterior es una estructura en la que se agregan dos elementos (descripci\u00f3n de referencia, imagen de referencia) para la prueba al conjunto de datos de &lt;Informaci\u00f3n sobre la cantidad de personas que suben y bajan por l\u00ednea y estaci\u00f3n de metro en Se\u00fal&gt; divulgado por Se\u00fal Gobierno Metropolitano.<\/p>\n\n\n\n<p>fuente:&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>El DDL que crea el esquema del modelo de datos de prueba anterior es el siguiente.<\/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>En AL32UTF8, se requieren 3 bytes para 1 car\u00e1cter coreano, por lo que la longitud de las dos columnas aumenta lo suficiente.<\/p>\n\n\n\n<p>Los archivos de datos en formato Excel se pueden descargar desde la ruta de github a continuaci\u00f3n.<\/p>\n\n\n\n<p>* Archivo de datos de Excel:&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\/N\u00famero de pasajeros por estaci\u00f3n de metro_Seoul Open Data_2013.xlsx<\/a><\/p>\n\n\n\n<p>El DML para ingresar datos en la tabla se puede descargar desde la ruta de github a continuaci\u00f3n.<\/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\/N\u00famero de pasajeros por estaci\u00f3n de metro_Seoul Open Data_2013.sql<\/a><\/p>\n\n\n\n<p>Algunos extractos del archivo sql anterior se pegan a continuaci\u00f3n.<\/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>Hasta ahora, hemos analizado la configuraci\u00f3n del entorno de prueba y los scripts de configuraci\u00f3n para la conversi\u00f3n del juego de caracteres de Oracle. A continuaci\u00f3n, veremos diferentes formas de transformar el conjunto de caracteres en este entorno de prueba. Veremos el m\u00e9todo recomendado por Oracle y el m\u00e9todo que requiere una implementaci\u00f3n separada.<\/p>","protected":false},"excerpt":{"rendered":"<p>Continuando con el art\u00edculo anterior, analizamos la configuraci\u00f3n del entorno de prueba de conversi\u00f3n del juego de caracteres de Oracle. Puede verificar la configuraci\u00f3n del entorno del servidor Oracle (tres instancias, creaci\u00f3n de DB Link), creaci\u00f3n de tablas de prueba y scripts de creaci\u00f3n de datos de prueba. Este entorno de prueba se us\u00f3 m\u00e1s tarde en el proceso de conversi\u00f3n del juego de caracteres...<\/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.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\/es\/oracle-character-set-migration-4-test-environment\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\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\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conversi\u00f3n del conjunto de caracteres de Oracle (4): 4. Configuraci\u00f3n del entorno de prueba - Habilidad de productividad","description":"Siguiendo con el art\u00edculo anterior, examinaremos la configuraci\u00f3n del entorno de prueba de conversi\u00f3n del conjunto de caracteres de Oracle. Encontrar\u00e1 scripts para configurar el entorno del servidor Oracle (tres instancias, creando un enlace a la base de datos), crear tablas de prueba y crear datos de prueba.","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\/es\/oracle-character-set-migration-4-test-environment\/","og_locale":"es_ES","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\/es\/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":{"Escrito por":"Zerom","Tiempo de lectura":"5 minutos"},"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":"es","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":"Conversi\u00f3n del conjunto de caracteres de Oracle (4): 4. Configuraci\u00f3n del entorno de prueba - Habilidad de productividad","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":"Siguiendo con el art\u00edculo anterior, examinaremos la configuraci\u00f3n del entorno de prueba de conversi\u00f3n del conjunto de caracteres de Oracle. Encontrar\u00e1 scripts para configurar el entorno del servidor Oracle (tres instancias, creando un enlace a la base de datos), crear tablas de prueba y crear datos de prueba.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","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":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11936"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11938"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11936"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}