{"id":11958,"date":"2022-10-03T15:10:08","date_gmt":"2022-10-03T06:10:08","guid":{"rendered":"https:\/\/prodskill.com\/?p=11958"},"modified":"2022-10-05T00:09:13","modified_gmt":"2022-10-04T15:09:13","slug":"oracle-character-set-migration-8-datapump-export-import","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/","title":{"rendered":"Conversi\u00f3n de conjuntos de caracteres de Oracle(8): 6. C\u00f3mo convertir un conjunto de caracteres implementado por el usuario (1)"},"content":{"rendered":"<p>Echemos un vistazo al m\u00e9todo de conversi\u00f3n de conjunto de caracteres implementado por el usuario. Puede comprobar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 utilizando Oracle Utility Data Pump Export, Import.<\/p>\n\n\n\n<p>Para los m\u00e9todos que requieren una implementaci\u00f3n separada, Oracle no garantiza la conversi\u00f3n y el implementador debe garantizar la conversi\u00f3n, por lo que la precisi\u00f3n debe verificarse mediante verificaci\u00f3n t\u00e9cnica y pruebas para varios casos.<\/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-7-ko16mswin949-csscan-result\/\">Conversi\u00f3n de juego de caracteres de Oracle (7): 5.4. KO16MSWIN949 Entorno CSSCAN Resultado de ejecuci\u00f3n<\/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-8-datapump-export-import\/#6_%EC%82%AC%EC%9A%A9%EC%9E%90_%EA%B5%AC%ED%98%84_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\" >6. C\u00f3mo convertir un juego de caracteres implementado por el usuario<\/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-8-datapump-export-import\/#61_Third_party_tool_%EC%A0%81%EC%9A%A9_%EB%B0%A9%EB%B2%95_%E2%80%93_ETL_%EB%93%B1\" >6.1. C\u00f3mo aplicar herramientas de terceros \u2013 ETL, etc.<\/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-8-datapump-export-import\/#62_Oracle_Utility_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >6.2. C\u00f3mo utilizar la utilidad de Oracle<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/#621_%EB%B0%A9%EB%B2%951_Data_Pump_ExportImport\" >6.2.1. M\u00e9todo 1) Exportaci\u00f3n\/importaci\u00f3n de bomba de datos<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/#622_%EB%B0%A9%EB%B2%952_SQLLoader\" >6.2.2. M\u00e9todo 2) SQL*Loader<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"6.\uad6c\ud604\uc774_\ud544\uc694\ud55c_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"6_%EC%82%AC%EC%9A%A9%EC%9E%90_%EA%B5%AC%ED%98%84_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\"><\/span>6. C\u00f3mo convertir un juego de caracteres implementado por el usuario<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6.1._Third_party_tool_\uc801\uc6a9_\ubc29\ubc95_-_ETL_\ub4f1\"><span class=\"ez-toc-section\" id=\"61_Third_party_tool_%EC%A0%81%EC%9A%A9_%EB%B0%A9%EB%B2%95_%E2%80%93_ETL_%EB%93%B1\"><\/span>6.1. C\u00f3mo aplicar herramientas de terceros \u2013 ETL, etc.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Este es un m\u00e9todo para implementar la conversi\u00f3n de conjuntos de caracteres utilizando herramientas ETL que son bien conocidas en el mercado (por ejemplo, Informatica PowerCenter, IBM DataStage, etc.).<\/p>\n\n\n\n<p>Es un m\u00e9todo con el que no tengo experiencia directa, y solo s\u00e9 que es posible, por lo que no describir\u00e9 el m\u00e9todo detallado.<\/p>\n\n\n\n<p>Sin embargo, revise solo las consideraciones a continuaci\u00f3n.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Cada producto incurre en un costo de compra, o se requieren costos adicionales de mano de obra de desarrollo, incluso si ya se ha comprado.<\/li><li>Tambi\u00e9n se pueden considerar TOS de c\u00f3digo abierto (Talend Open Studio)-DI, Pentaho Kettle, etc.<\/li><li>En el caso de escribir datos de la base de datos de origen en un archivo y leer e insertar el archivo en la base de datos de destino, el separador de columnas y el separador de filas se incluyen en el valor de los datos y manejan errores como ser empujado por una columna o una fila siendo guardado incorrectamente como varias filas. es absolutamente necesario<\/li><li>Al seleccionar una herramienta inicial, es necesario realizar una prueba piloto en una mesa de gran capacidad para seleccionar una herramienta adecuada, y es importante asegurar personal de desarrollo de ETL con mucha experiencia.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6.2._Oracle_Utility_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"62_Oracle_Utility_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>6.2. C\u00f3mo utilizar la utilidad de Oracle<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Veremos tres formas de implementar la conversi\u00f3n de juegos de caracteres aprovechando las funciones y utilidades de Oracle.<\/p>\n\n\n\n<p><strong>1. Utilizar la exportaci\u00f3n\/importaci\u00f3n de la bomba de datos<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Forzar cambio de conjunto de caracteres: ALTER DATABASE CHARACTER SET INTERNAL<\/li><li>Ejecutar exportaci\u00f3n\/importaci\u00f3n: aplicar el mismo NLS_LANG que el conjunto de caracteres de destino<\/li><\/ul>\n\n\n\n<p><strong>2. Uso de SQL*Loader<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Descarga de datos de la base de datos fuente: formato utilizable en SQL*Loader, requiere desarrollo en PL\/SQL, Pro*C, Java, etc.<\/li><li>Cargue datos en la base de datos de destino con SQL*Loader<\/li><\/ul>\n\n\n\n<p><strong>3. Usando DB Link y CTAS y UTL_RAW<\/strong><br>(Ver art\u00edculo separado: <a href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\">Conversi\u00f3n de juegos de caracteres de Oracle (9): 6. C\u00f3mo convertir juegos de caracteres implementados por el usuario (2)<\/a><strong>)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Crear enlace de base de datos: cree un enlace de base de datos que apunte desde el destino al origen<\/li><li>Creaci\u00f3n de vista: conversi\u00f3n de vista de columnas CHAR, VARCHAR2 desde el origen a UTL_RAW.CAST_TO_RAW<\/li><li>Cargue datos en CTAS: aplique la funci\u00f3n UTL_RAW.CAST_TO_VARCHAR2 y CONVERT mientras ejecuta CTAS (Crear tabla como selecci\u00f3n) desde Target a DB Link<\/li><\/ul>\n\n\n\n<p>Las ventajas y desventajas de cada m\u00e9todo se resumen a continuaci\u00f3n.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Manera<\/strong><\/td><td><strong>Ventajas<\/strong><\/td><td><strong>Desventajas<\/strong><\/td><\/tr><tr><td>1. Exportaci\u00f3n\/Importaci\u00f3n de bomba de datos<\/td><td>\u2013 Procesamiento paralelo posible<br>\u2013 El procesamiento de excepciones, como car\u00e1cter de nueva l\u00ednea, car\u00e1cter especial, car\u00e1cter nulo, no es necesario<\/td><td>\u2013 Tiempo de descarga de datos requerido<br>\u2013 En caso de que la base de datos de origen sea US7ASCII<br>&nbsp; . Se requiere cambio de juego de caracteres (se requiere preservaci\u00f3n original)<br>&nbsp; . Se requiere conversi\u00f3n adicional de datos de tipo CLOB<\/td><\/tr><tr><td>2. Cargador SQL*<\/td><td>\u2013 Procesamiento paralelo posible<\/td><td>\u2013 Necesidad de desarrollar una funci\u00f3n para crear (descargar) un archivo de datos<br>\u2013 Manejo de excepciones\/errores requerido durante el procesamiento de archivos de descarga\/carga (car\u00e1cter de nueva l\u00ednea, car\u00e1cter especial, car\u00e1cter nulo, etc.)<br>\u2013 Tiempo de descarga de datos requerido<\/td><\/tr><tr><td>3. Enlace de base de datos y CTAS y UTL_RAW<\/td><td>\u2013 No se requiere tiempo de descarga de datos<\/td><td>\u2013 El procesamiento en paralelo es dif\u00edcil con la sugerencia Parallel (necesidad de procesar dividiendo directamente el rango de datos)<br>\u2013 No aplicable a datos que excedan los 2000 bytes (la longitud m\u00e1xima del tipo RAW es de 2000 bytes)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Mientras revisa estos m\u00e9todos, tenga en cuenta las siguientes consideraciones:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Al convertir de US7ASCII a AL32UTF8 mediante el m\u00e9todo de exportaci\u00f3n\/importaci\u00f3n de bomba de datos, El juego de caracteres de la base de datos original debe cambiarse con DDL<ul><li>No se recomienda cambiar la base de datos original directamente. Si sale mal, puede ser muy dif\u00edcil revertirlo.<\/li><li>Si ya se configur\u00f3 una base de datos para conmutaci\u00f3n por error, es deseable utilizarla o configurar y cambiar una base de datos de replicaci\u00f3n separada.<\/li><li>Alternativamente, es posible restaurar los datos de respaldo de la base de datos original en un servidor separado y usarlos.<\/li><li>Adem\u00e1s, es conveniente revisar varios m\u00e9todos (replicaci\u00f3n de disco, etc.) para configurar una base de datos de replicaci\u00f3n y seleccionar un m\u00e9todo teniendo en cuenta el costo y el tiempo.<\/li><li>Si es dif\u00edcil configurar una base de datos de replicaci\u00f3n, puede continuar despu\u00e9s de la copia de seguridad completa, pero si se requiere una recuperaci\u00f3n, el tiempo de inactividad del servicio puede ser prolongado seg\u00fan la cantidad de datos.<\/li><\/ul><\/li><li>A menos que se detenga el servicio, independientemente del m\u00e9todo que se aplique, el punto de extracci\u00f3n de la base de datos original debe coincidir para garantizar la coherencia de los datos (use FLASHBACK_SCN, FLASHBACK_TIME)<\/li><li>Adem\u00e1s, el m\u00e9todo de reflejar los datos modificados despu\u00e9s del punto de extracci\u00f3n debe probarse y prepararse con anticipaci\u00f3n (uso de CDC, etc.)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.2.1._\ubc29\ubc951)_Data_Pump_Export\/Import\"><span class=\"ez-toc-section\" id=\"621_%EB%B0%A9%EB%B2%951_Data_Pump_ExportImport\"><\/span>6.2.1. M\u00e9todo 1) Exportaci\u00f3n\/importaci\u00f3n de bomba de datos<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Preparaci\u00f3n: Use la siguiente secuencia de comandos para crear objetos de directorio y otorgar los permisos necesarios al ejecutar la exportaci\u00f3n\/importaci\u00f3n de bombeo de datos.&nbsp;<\/p>\n\n\n\n<p>Ejecute para cada instancia de Oracle que se probar\u00e1: ORAUS7, ORAMSWIN949 y ORAUTF.<\/p>\n\n\n\n<p>\u25bc Otorgar permisos a la instancia ORAUS7<\/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=\"\">-- ORAUS7 instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAUS7\nset NLS_LANG=AMERICAN_AMERICA.US7ASCII\nsqlplus sys\/________@oraus7 as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>\u25bc Otorgar permisos a la instancia ORAMSWIN949<\/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=\"\">-- ORAMSWIN949 instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAMSWIN949\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nsqlplus sys\/________@oramswin949 as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>\u25bc Autorizar la Instancia ORAUTF<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- ORAUTF instance\uc5d0 \uad8c\ud55c \ubd80\uc5ec\ntitle ORAUTF\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nsqlplus sys\/________@orautf as sysdba\nCREATE OR REPLACE DIRECTORY PUMP_DIR AS 'D:\\Temp\\datapump';\nGRANT READ, WRITE ON DIRECTORY PUMP_DIR TO LEG;\nEXIT<\/pre>\n\n\n\n<p>Echemos un vistazo a cada uno de los siguientes tres casos.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>KO16MSWIN949 a AL32UTF8<\/li><li>US7ASCII a AL32UTF8 (2 rutas)<\/li><li>US7ASCII a AL32UTF8 (1 ruta)<\/li><\/ol>\n\n\n\n<p>Como referencia, en el caso de la conversi\u00f3n de US7ASCII a AL32UTF8, las columnas de tipo CLOB no se convierten normalmente, por lo que se requiere un procesamiento por separado.<\/p>\n\n\n\n<p>Se explicar\u00e1 en el siguiente art\u00edculo.<\/p>\n\n\n\n<p><strong>1. KO16MSWIN949 a AL32UTF8<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\"><img loading=\"lazy\" decoding=\"async\" width=\"425\" height=\"256\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\" alt=\"1. KO16MSWIN949 to AL32UTF8 \uac1c\ub150\ub3c4\" class=\"wp-image-11959\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png 425w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86-48x29.png 48w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/a><figcaption>1. Diagrama conceptual de KO16MSWIN949 a AL32UTF8<\/figcaption><\/figure>\n<\/div>\n\n\n<p>En este caso, los tipos CHAR, VARCHAR2 y CLOB se convierten normalmente.<\/p>\n\n\n\n<p>El script de ejecuci\u00f3n para cada paso 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=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=PUMP_DIR dumpfile=oramswin949_leg.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nset NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949\nimpdp leg\/leg@orautf directory=PUMP_DIR dumpfile= oramswin949_leg.dmp logfile=orautf_leg_imp.log content=data_only<\/pre>\n\n\n\n<p><strong>2. US7ASCII a AL32UTF8 (2 rutas)<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"377\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png\" alt=\"2. US7ASCII to AL32UTF8 (2 path) \uac1c\ub150\ub3c4\" class=\"wp-image-11960\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87.png 624w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-87-48x29.png 48w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>2. Diagrama conceptual de US7ASCII a AL32UTF8 (2 rutas)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Tenga en cuenta lo siguiente:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>El servidor de base de datos de replicaci\u00f3n temporal es una base de datos que replica la base de datos de operaci\u00f3n tal como es en la misma forma que la original.<\/li><li>En el entorno de prueba, se utiliz\u00f3 la instancia ORAMSWIN949 como base de datos de replicaci\u00f3n temporal y los datos se replican con Data Pump. En este caso, el juego de caracteres debe cambiarse a US7ASCII antes de la replicaci\u00f3n.<\/li><li>En la aplicaci\u00f3n real, es conveniente configurar y utilizar por separado el servidor de base de datos de replicaci\u00f3n temporal con el conjunto de caracteres US7ASCII.<\/li><\/ul>\n\n\n\n<p>ORACLE no recomienda este m\u00e9todo y requiere un proceso de conversi\u00f3n independiente porque los datos de tipo CLOB normalmente no se convierten.<\/p>\n\n\n\n<p>El script de ejecuci\u00f3n para cada paso 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=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41-1\n-- \uc2e4\ud589 Instance: ORAUS7\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\nset NLS_LANG=US7ASCII\nexpdp leg\/leg@oraus7 directory=MIG_DIR dumpfile=oraus7_leg_exp.dmp logfile=oraus7_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc41-2\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nset NLS_LANG=US7ASCII\nimpdp leg\/leg@oramswin949 directory= MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Character Set \ubcc0\uacbd\n-- Tool: SQL*Plus\nSHUTDOWN IMMEDIATE;\nSTARTUP MOUNT;\nALTER SYSTEM ENABLE RESTRICTED SESSION;\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\nALTER DATABASE OPEN;\nALTER DATABASE CHARACTER SET INTERNAL_USE KO16MSWIN949;\nSHUTDOWN IMMEDIATE;\nSTARTUP;\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAMSWIN949\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n-- sql*plus\uc5d0\uc11c \ud55c\uae00 \ud45c\uc2dc \ub418\ub294\uc9c0 \ud655\uc778 \ud6c4 \ub2e4\uc74c \uc2e4\ud589\nset NLS_LANG=KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc44\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc45\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nimpdp leg\/leg@orautf directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log content=data_only<\/pre>\n\n\n\n<p><strong>3. US7ASCII a AL32UTF8 (1 ruta)<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png\"><img loading=\"lazy\" decoding=\"async\" width=\"426\" height=\"404\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png\" alt=\"3. US7ASCII to AL32UTF8 (1 path) \uac1c\ub150\ub3c4\" class=\"wp-image-11961\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88.png 426w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-300x285.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-36x34.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-88-48x46.png 48w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/a><figcaption>3. Diagrama conceptual de US7ASCII a AL32UTF8 (1 ruta)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>ORACLE no recomienda este m\u00e9todo y requiere un proceso de conversi\u00f3n independiente porque los datos de tipo CLOB normalmente no se convierten.<\/p>\n\n\n\n<p>Adem\u00e1s, dado que se cambia el conjunto de caracteres de la base de datos operativa, los datos originales no se pueden conservar, lo que dificulta la reversi\u00f3n en caso de error. Por lo tanto, no se debe aplicar al entorno operativo si es posible.<\/p>\n\n\n\n<p>Si usa este m\u00e9todo inevitablemente, apl\u00edquelo al entorno de producci\u00f3n despu\u00e9s de verificarlo suficientemente en el entorno de prueba.<\/p>\n\n\n\n<p>El script de ejecuci\u00f3n para cada paso 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=\"\">--------------------------------------------------------------------\n-- \ub2e8\uacc41\n-- \uc2e4\ud589 Instance: ORAUS7\n-- NLS_LANG: US7ASCII\n-- \uc791\uc5c5\uba85: Character Set \ubcc0\uacbd\n-- Tool: SQL*Plus\nSHUTDOWN IMMEDIATE;\nSTARTUP MOUNT;\nALTER SYSTEM ENABLE RESTRICTED SESSION;\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\nALTER DATABASE OPEN;\nALTER DATABASE CHARACTER SET INTERNAL_USE KO16MSWIN949;\nSHUTDOWN IMMEDIATE;\nSTARTUP;\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc42\n-- \uc2e4\ud589 Instance: ORAMSWIN949(=ORAUS7)\n-- NLS_LANG: KO16MSWIN949\n-- \uc791\uc5c5\uba85: Datapump Export\n-- Tool: expdp\n-- sql*plus\uc5d0\uc11c \ud55c\uae00 \ud45c\uc2dc \ub418\ub294\uc9c0 \ud655\uc778 \ud6c4 \ub2e4\uc74c \uc2e4\ud589\nset NLS_LANG=KO16MSWIN949\nexpdp leg\/leg@oramswin949 directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_exp.log schemas=leg\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc43\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Table \uc0dd\uc131\n-- Tool: SQL*Plus\n\n-- Target table\uc744 \ubbf8\ub9ac \uc0dd\uc131\n-- LINE_NUM, SUB_STA_NM \uceec\ub7fc \uae38\uc774 \uc99d\uac00\n-- COMMT \uceec\ub7fc \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd(VARCHAR2 -> CLOB)\nCREATE TABLE SUB_MON_STAT \n(\n     USE_MON            VARCHAR2(8),\n     LINE_NUM           VARCHAR2(50),  -- 14 -> 50\n     SUB_STA_ID         VARCHAR2(4),\n     SUB_STA_NM         VARCHAR2(100), -- 20 -> 100\n     RIDE_PASGR_NUM     NUMBER(10),\n     ALIGHT_PASGR_NUM   NUMBER(10),\n     WORK_DT            VARCHAR2(8),\n     COMMT              CLOB,          -- VARCHAR2 -> CLOB\n     REF_DES            CLOB,\n     REF_IMG            BLOB\n);\n\n\n--------------------------------------------------------------------\n-- \ub2e8\uacc44\n-- \uc2e4\ud589 Instance: ORAUTF\n-- NLS_LANG: AL32UTF8\n-- \uc791\uc5c5\uba85: Datapump Import\n-- Tool: impdp\nimpdp leg\/leg@orautf directory=MIG_DIR dumpfile=oramswin949_leg_exp.dmp logfile=oramswin949_leg_imp.log content=data_only<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.2.2._\ubc29\ubc952)_SQL*Loader\"><span class=\"ez-toc-section\" id=\"622_%EB%B0%A9%EB%B2%952_SQLLoader\"><\/span>6.2.2. M\u00e9todo 2) SQL*Loader<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>SQL*Loader requiere un archivo de control y un archivo de datos. Entre ellos, el archivo de datos contiene los datos reales.<\/p>\n\n\n\n<p>Para crear este archivo de datos, puede crearlo usted mismo utilizando varias herramientas, como PL\/SQL, Pro*C y Java, o utilizarlo tal como est\u00e1 haciendo referencia al c\u00f3digo fuente que ya ha implementado la misma funci\u00f3n, o ampliar ligeramente eso.<\/p>\n\n\n\n<p>Aqu\u00ed, no presentamos c\u00f3mo hacerlo directamente, sino solo la URL del c\u00f3digo fuente implementado.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\" style=\"font-size:17px\"><p>Blog de Tom Kyte, autor de Oracle efectivo: <a href=\"https:\/\/asktom.oracle.com\/Misc\/httpasktomoraclecomtkyteflat.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/asktom.oracle.com\/Misc\/httpasktomoraclecomtkyteflat.html<\/a><\/p><\/blockquote>\n\n\n\n<p>Adem\u00e1s, si busca en Google, encontrar\u00e1 el c\u00f3digo fuente que puede consultar.<\/p>\n\n\n\n<p>Despu\u00e9s de crear archivos de datos en unidades de tabla o partici\u00f3n, ejecute sqlldr simult\u00e1neamente en varios grupos para cargarlos en paralelo y minimizar el tiempo de ejecuci\u00f3n con un nivel de carga adecuado.<\/p>","protected":false},"excerpt":{"rendered":"<p>Echemos un vistazo al m\u00e9todo de conversi\u00f3n de conjunto de caracteres implementado por el usuario. Puede comprobar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 utilizando Oracle Utility Data Pump Export, Import. Los m\u00e9todos que requieren una implementaci\u00f3n separada requieren verificaci\u00f3n t\u00e9cnica y varios...<\/p>","protected":false},"author":1,"featured_media":11959,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249,254,255,256,257,258,259],"class_list":["post-11958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949","tag-data-pump","tag-export","tag-import","tag-al32utf8"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/\" \/>\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(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T06:10:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:09:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\" \/>\n\t<meta property=\"og:image:width\" content=\"425\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"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=\"9 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-8-datapump-export-import\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)\",\"datePublished\":\"2022-10-03T06:10:08+00:00\",\"dateModified\":\"2022-10-04T15:09:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\"},\"wordCount\":561,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"Data Pump\",\"Export\",\"Import\",\"AL32UTF8\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\",\"url\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\",\"datePublished\":\"2022-10-03T06:10:08+00:00\",\"dateModified\":\"2022-10-04T15:09:13+00:00\",\"description\":\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png\",\"width\":425,\"height\":256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"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 de conjuntos de caracteres de Oracle (8): 6. M\u00e9todo de conversi\u00f3n de conjuntos de caracteres implementado por el usuario (1) - Habilidad de productividad","description":"Echemos un vistazo al m\u00e9todo de conversi\u00f3n de conjunto de caracteres implementado por el usuario. Puede comprobar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 utilizando Oracle Utility Data Pump Export, Import.","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-8-datapump-export-import\/","og_locale":"es_ES","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Oracle Utitlity\uc778 Data Pump Export, Import\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T06:10:08+00:00","article_modified_time":"2022-10-04T15:09:13+00:00","og_image":[{"width":425,"height":256,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"9 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)","datePublished":"2022-10-03T06:10:08+00:00","dateModified":"2022-10-04T15:09:13+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"},"wordCount":561,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","Data Pump","Export","Import","AL32UTF8"],"articleSection":["ORACLE"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/","name":"Conversi\u00f3n de conjuntos de caracteres de Oracle (8): 6. M\u00e9todo de conversi\u00f3n de conjuntos de caracteres implementado por el usuario (1) - Habilidad de productividad","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","datePublished":"2022-10-03T06:10:08+00:00","dateModified":"2022-10-04T15:09:13+00:00","description":"Echemos un vistazo al m\u00e9todo de conversi\u00f3n de conjunto de caracteres implementado por el usuario. Puede comprobar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 utilizando Oracle Utility Data Pump Export, Import.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-86.png","width":425,"height":256},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"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\/11958","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=11958"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11958\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11959"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11958"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}