{"id":11940,"date":"2022-10-03T11:40:51","date_gmt":"2022-10-03T02:40:51","guid":{"rendered":"https:\/\/prodskill.com\/?p=11940"},"modified":"2022-10-05T00:04:30","modified_gmt":"2022-10-04T15:04:30","slug":"oracle-character-set-migration-5-oracle-recommendation","status":"publish","type":"post","link":"https:\/\/prodskill.com\/de\/oracle-character-set-migration-5-oracle-recommendation\/","title":{"rendered":"Oracle-Zeichensatzkonvertierung (5): 5. Von Oracle empfohlene Vorgehensweise"},"content":{"rendered":"\n<p>Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. CSALTER \uc0ac\uc6a9 \ubc29\ubc95\uacfc \ud55c\uacc4\uc810, CSSCAN \uc0ac\uc6a9 \ubc29\ubc95\uacfc \uc2e4\ud589 \uc21c\uc11c, \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c, CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table\uc744 \uc0dd\uc131\ud558\ub294 DDL\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804 \uae00\uc5d0\uc11c \uc774\uc5b4\uc9c0\ub294 \ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/oracle-character-set-migration-4-test-environment\/\">Oracle Character Set \ubcc0\ud658(4): 4.\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\uc131<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;\ubaa9\ucc28&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/de\/oracle-character-set-migration-5-oracle-recommendation\/#5_Oracle_%EA%B6%8C%EC%9E%A5_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95_CSALTER_CSSCAN\" >5. Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 (CSALTER, CSSCAN)<\/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-5-oracle-recommendation\/#51_CSALTER_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >5.1. CSALTER \uc0ac\uc6a9 \ubc29\ubc95<\/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-5-oracle-recommendation\/#52_CSSCAN_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >5.2. CSSCAN \uc0ac\uc6a9 \ubc29\ubc95<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/de\/oracle-character-set-migration-5-oracle-recommendation\/#521_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC_%EC%A0%80%EC%9E%A5_Table\" >5.2.1. CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"5._Oracle_\uad8c\uc7a5_Character_Set_\ubcc0\ud658_\ubc29\ubc95_(CSALTER,_CSSCAN)\"><span class=\"ez-toc-section\" id=\"5_Oracle_%EA%B6%8C%EC%9E%A5_Character_Set_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95_CSALTER_CSSCAN\"><\/span>5. Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 (CSALTER, CSSCAN)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Oracle\uc740 Full Export &amp; Import \ubc29\ubc95\uacfc CSALTER script\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uad8c\uc7a5\ud558\uace0 \uc788\ub2e4. \uc774 \uc911 \uba3c\uc800 CSALTER\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.1._CSALTER_\uc0ac\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"51_CSALTER_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>5.1. CSALTER \uc0ac\uc6a9 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Oracle \ubb38\uc11c\ub294 \uc544\ub798 URL\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch11charsetmig.htm#NLSPG469\" target=\"_blank\" rel=\"noreferrer noopener\">Migrating a Character Set Using the CSALTER Script (https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch11charsetmig.htm#NLSPG469)<\/a><\/p>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 character set\uc744 \ubcc0\uacbd\ud558\uae30 \uc704\ud574\uc11c \ub2e4\uc74c \uc808\ucc28\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Shut down the database, using either a&nbsp;SHUTDOWN IMMEDIATE&nbsp;or a&nbsp;SHUTDOWN NORMAL&nbsp;statement.<\/li><li>Do a full backup of the database, because the&nbsp;CSALTER&nbsp;script cannot be rolled back.<\/li><li>Start up the database.<\/li><li>Run the Database Character Set Scanner utility.<br>CSSCAN \/AS SYSDBA FULL=Y&#8230;<\/li><li>Run the&nbsp;CSALTER&nbsp;script.<br>@@CSALTER.PLB<br>SHUTDOWN IMMEDIATE; &#8212; or SHUTDOWN NORMAL;<br>STARTUP;<\/li><\/ol>\n\n\n\n<p>\ud558\uc9c0\ub9cc CSALTER\ub294 \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ud55c \ub370\uc774\ud130\ub294 \ubcc0\ud658\ud558\uc9c0 \uc54a\ub294\ub2e4. (\uc704 URL\uc758 \ubb38\uc11c \ub0b4\uc6a9 \uc77c\ubd80 \ubc1c\ucdcc)<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Note that <span style=\"background-color: #f6e199;\">the CSALTER script does not perform any user data conversion.<\/span> It only changes the character set metadata in the data dictionary. Thus, after the CSALTER operation, Oracle behaves as if the database was created using the new character set.<\/p><\/blockquote>\n\n\n\n<p>\uc774\uac83\uc740 CSALTER\uc758 \ud55c\uacc4\uc810\uc774\uace0, CSALTER\ub97c character set \ubcc0\ud658\uc5d0 \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \ub300\ubd80\ubd84\uc758 application \ud658\uacbd\uc5d0\uc11c \uc801\ud569\ud558\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\ub9cc, CSSCAN(Database Character Set Scanner utility)\ub294 \ubcc0\ud658 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \ubcc0\ud658 \uac00\ub2a5\ud55c \ub370\uc774\ud130\uc640 \ubcc0\ud658\uc2dc \ubb38\uc81c\uac00 \ub418\ub294 \ub370\uc774\ud130\ub97c \ubbf8\ub9ac \ud30c\uc545\ud558\ub294 \uc6a9\ub3c4\ub85c \uc0ac\uc6a9\ud560\ub9cc \ud558\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.2._CSSCAN_\uc0ac\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"52_CSSCAN_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>5.2. CSSCAN \uc0ac\uc6a9 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ub2e4\uc74c \uba85\ub839\uc5b4\ub85c csscan \uc2e4\ud589\uc5d0 \ud544\uc694\ud55c parameter\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>csscan help=y<\/p><\/blockquote>\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-85.png\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"817\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\" alt=\"oracle csscan help\" class=\"wp-image-11941\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png 739w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85-271x300.png 271w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85-11x12.png 11w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85-22x24.png 22w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85-33x36.png 33w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85-43x48.png 43w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><figcaption>oracle csscan help<\/figcaption><\/figure>\n<\/div>\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=\"\">C:\\Users\\ymlee>csscan help=y\n\n\nCharacter Set Scanner v2.2 : Release 11.2.0.1.0 - Production on \uc77c 3\uc6d4 20 22:58:48 2022\n\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\n\n\nYou can let Scanner prompt you for parameters by entering the CSSCAN\ncommand followed by your username\/password:\n\n  Example: CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\"\n\nOr, you can control how Scanner runs by entering the CSSCAN command\nfollowed by various parameters. To specify parameters, you use keywords:\n\n  Example:\n    CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\" FULL=y TOCHAR=utf8 ARRAY=1024000 PROCESS=3\n\nKeyword    Default Prompt Description\n---------- ------- ------ -------------------------------------------------\nUSERID             yes    username\/password\nFULL       N       yes    scan entire database\nUSER               yes    owner of tables to be scanned\nTABLE              yes    list of tables to scan\nCOLUMN             yes    list of columns to scan\nEXCLUDE                   list of tables to exclude from scan\nTOCHAR             yes    new database character set name\nFROMCHAR                  current database character set name\nTONCHAR                   new national character set name\nFROMNCHAR                 current national character set name\nARRAY      1024000 yes    size of array fetch buffer\nPROCESS    1       yes    number of concurrent scan process\nMAXBLOCKS                 split table if block size exceed MAXBLOCKS\nCAPTURE    N              capture convertible data\nSUPPRESS                  maximum number of exceptions logged for each table\nFEEDBACK                  report progress every N rows\nBOUNDARIES                list of column size boundaries for summary report\nLASTRPT    N              generate report of the last database scan\nLOG        scan           base file name of report files\nPARFILE                   parameter file name\nPRESERVE   N              preserve existing scan results\nLCSD       N       no     enable language and character set detection\nLCSDDATA   LOSSY   no     define the scope of the detection\nHELP       N              show help screen (this screen)\nQUERY      N              select clause to scan subset of tables or columns\n---------- ------- ------ -------------------------------------------------\nScanner terminated successfully.<\/pre>\n\n\n\n<p>\uac01 parameter\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc124\uba85\uc740 \ub2e4\uc74c URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#NLSPG498\" target=\"_blank\" rel=\"noreferrer noopener\">Database&nbsp;Character&nbsp;Set&nbsp;Scanner&nbsp;Parameters (https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#NLSPG498)<\/a><\/p>\n\n\n\n<p>csscan\uc740 \ub2e4\uc74c \uc21c\uc11c\ub85c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>schema \uc0dd\uc131: $ORACLE_HOME\/rdbms\/admin\/csminst.sql \uc2e4\ud589<\/li><li>directory \uc0dd\uc131: D:\\temp\\csscan \uc0dd\uc131 (\uc2e4\ud589\uacb0\uacfc \ud30c\uc77c \uc800\uc7a5 \uc6a9\ub3c4)<\/li><li>csscan \uc2e4\ud589<\/li><li>csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778<\/li><\/ol>\n\n\n\n<p>csscan \uc2e4\ud589\uacb0\uacfc\ub85c \uc138 \uac1c\uc758 \ud30c\uc77c\uc774 \uc0dd\uc131\ub41c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>scan.txt: scan \uacb0\uacfc \uc694\uc57d \ubcf4\uace0\uc11c<\/li><li>scan.out: scan \ub300\uc0c1 \ud14c\uc774\ube14 \uc815\ubcf4<\/li><li>scan.err: \uc624\ub958 \uc0c1\uc138 \ub0b4\uc5ed<\/li><\/ul>\n\n\n\n<p>scan.txt (scan \uacb0\uacfc \uc694\uc57d \ubcf4\uace0\uc11c)\ub294 \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4. (\ud074\ub9ad\uc2dc oracle \ubb38\uc11c\ub85c \uc774\ub3d9)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#CCHJADJE\" target=\"_blank\" rel=\"noreferrer noopener\">Database Size<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1009090\" target=\"_blank\" rel=\"noreferrer noopener\">Database Scan Parameters<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#CCHCEJFB\" target=\"_blank\" rel=\"noreferrer noopener\">Scan Summary<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1006924\" target=\"_blank\" rel=\"noreferrer noopener\">Data Dictionary Conversion Summary<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1006966\" target=\"_blank\" rel=\"noreferrer noopener\">Application Data Conversion Summary<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1011892\" target=\"_blank\" rel=\"noreferrer noopener\">Application Data Conversion Summary Per Column Size Boundary<\/a>: BOUNDARIES parameter \uc9c0\uc815\ud55c \uacbd\uc6b0\ub9cc \ucd9c\ub825<\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1007046\" target=\"_blank\" rel=\"noreferrer noopener\">Distribution of Convertible Data Per Table<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1011938\" target=\"_blank\" rel=\"noreferrer noopener\">Distribution of Convertible Data Per Column<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1007086\" target=\"_blank\" rel=\"noreferrer noopener\">Indexes To Be Rebuilt<\/a><\/li><li><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#i1009124\" target=\"_blank\" rel=\"noreferrer noopener\">Truncation Due To Character Semantics<\/a><\/li><\/ul>\n\n\n\n<p>[Data Conversion Summary] \ub0b4\uc6a9\uc5d0\uc11c Changeless, Convertible, Truncation, Lossy\uc5d0 \ub300\ud55c \uc124\uba85\uc740 \uc544\ub798 \ubb38\uc11c\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#g1019330\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch12scanner.htm#g1019330<\/a><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Status<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><tr><td>Changeless<\/td><td>Data remains the same in the new character set<br>&#8211;&nbsp;character set \ubcc0\ud658\uc2dc \ub370\uc774\ud130 \ubcc0\uacbd\uc5c6\uc74c<\/td><\/tr><tr><td>Convertible<\/td><td>Data can be successfully converted to the new character set<br>&#8211;&nbsp;character&nbsp;set&nbsp;\ubcc0\ud658\uc2dc&nbsp;\ub370\uc774\ud130 \ubcc0\uacbd \uac00\ub2a5\ud568<\/td><\/tr><tr><td>Truncation<\/td><td>Data will be truncated if conversion takes place<br>&#8211; character set \ubcc0\ud658\uc2dc \ub370\uc774\ud130 \uc798\ub9bc<\/td><\/tr><tr><td>Lossy<\/td><td>Character data will be lost if conversion takes place<br>&#8211; character set \ubcc0\ud658\uc2dc \ub370\uc774\ud130 \uc190\uc2e4\ub428(\uae68\uc9d0)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.2.1._CSSCAN_\uc2e4\ud589_\uacb0\uacfc_\uc800\uc7a5_Table\"><span class=\"ez-toc-section\" id=\"521_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC_%EC%A0%80%EC%9E%A5_Table\"><\/span>5.2.1. CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>csminst.sql \uc2e4\ud589\uc2dc \uc0dd\uc131\ub418\ub294 \uc5ec\ub7ec table \uc911 \uc544\ub798 table\uc5d0 csscan \uacb0\uacfc\uac00 \uc800\uc7a5\ub41c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CSM$TABLES<\/li><li>CSM$COLUMNS<\/li><li>CSM$ERRORS<\/li><\/ul>\n\n\n\n<p>\uc8fc\uc758\ud560 \uc810\uc740 \ub9e4\ubc88 CSSCAN \uc2e4\ud589\uc2dc\ub9c8\ub2e4 \uc774 table\uc758 \ub370\uc774\ud130\ub294 \ubaa8\ub450 \ucd08\uae30\ud654\ub41c\ub2e4\ub294 \uc810\uc774\ub2e4.(scan.txt, scan.out, scan.err \ud30c\uc77c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ucd08\uae30\ud654\ub41c\ub2e4)<\/p>\n\n\n\n<p>CSSCAN\uc744 \uc5ec\ub7ec \ubc88 \uc2e4\ud589\ud558\uba74\uc11c \uacb0\uacfc\ub97c \ube44\uad50\ud558\uace0\uc790 \ud560 \uacbd\uc6b0\ub294 \ubcc4\ub3c4 table\ub85c \ubc31\uc5c5\ud574 \ub450\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<p>\ubc31\uc5c5\uc2dc\uc5d0\ub294 \uc544\ub798 DDL\uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE  TABLE Z_CSSCAN_COL_SUMMARY\nAS\nSELECT  '20140507' BASE_DT, U.USERNAME, TC.TABLE_NAME, TC.COLUMN_NAME\n       ,CC.NUMROWS, CC.NULCNT, CC.CNVCNT, CC.CNVTYPE, CC.ERRCNT, CC.SIZERR\n       ,CC.CNVERR, CC.MAXSIZ, CC.CHRSIZ\n  FROM  CSMIG.CSM$COLUMNS CC INNER JOIN DBA_USERS U\n          ON   (CC.USR# = U.USER_ID)\n        INNER JOIN DBA_OBJECTS O\n          ON   (CC.OBJ# = O.OBJECT_ID)\n        INNER JOIN DBA_TAB_COLUMNS TC\n          ON   (CC.COL# = TC.COLUMN_ID\n            AND O.OBJECT_NAME = TC.TABLE_NAME)\n WHERE  1=1\n   AND  U.USERNAME = 'LEG'\n   AND  O.OBJECT_TYPE = 'TABLE'\n   AND  CC.ERRCNT &lt;> 0;<\/pre>\n\n\n\n<p>\uc704 DDL\uc758 \uc2e4\ud589\uacb0\uacfc\ub85c \uc0dd\uc131\ub418\ub294 \ub370\uc774\ud130 \uc0d8\ud50c\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\" style=\"font-size:14px\"><table><tbody><tr><td><strong>Row#<\/strong><\/td><td><strong>BASE_DT<\/strong><\/td><td><strong>USERNAME<\/strong><\/td><td><strong>TABLE_NAME<\/strong><\/td><td><strong>COLUMN_NAME<\/strong><\/td><td><strong>NUMROWS<\/strong><\/td><td><strong>NULCNT<\/strong><\/td><td><strong>CNVCNT<\/strong><\/td><td><strong>CNVTYPE<\/strong><\/td><td><strong>ERRCNT<\/strong><\/td><td><strong>SIZERR<\/strong><\/td><td><strong>CNVERR<\/strong><\/td><td><strong>MAXSIZ<\/strong><\/td><td><strong>CHRSIZ<\/strong><\/td><\/tr><tr><td>1<\/td><td>20140507<\/td><td>LEG<\/td><td>Z_TEST<\/td><td>VAL<\/td><td>2<\/td><td>0<\/td><td>0<\/td><td>0<\/td><td>2<\/td><td>0<\/td><td>2<\/td><td>12<\/td><td>0<\/td><\/tr><tr><td>2<\/td><td>20140507<\/td><td>LEG<\/td><td>SUB_MON_STAT<\/td><td>LINE_NUM<\/td><td>7426<\/td><td>0<\/td><td>0<\/td><td>0<\/td><td>7426<\/td><td>3238<\/td><td>7426<\/td><td>38<\/td><td>0<\/td><\/tr><tr><td>3<\/td><td>20140507<\/td><td>LEG<\/td><td>SUB_MON_STAT<\/td><td>SUB_STA_NM<\/td><td>7426<\/td><td>0<\/td><td>0<\/td><td>0<\/td><td>7426<\/td><td>1268<\/td><td>7426<\/td><td>54<\/td><td>0<\/td><\/tr><tr><td>4<\/td><td>20140507<\/td><td>LEG<\/td><td>SUB_MON_STAT<\/td><td>COMMT<\/td><td>7426<\/td><td>7425<\/td><td>0<\/td><td>0<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>9000<\/td><td>0<\/td><\/tr><tr><td>5<\/td><td>20140507<\/td><td>LEG<\/td><td>SUB_MON_STAT<\/td><td>REF_DES<\/td><td>7426<\/td><td>7425<\/td><td>0<\/td><td>0<\/td><td>1<\/td><td>0<\/td><td>1<\/td><td>3000<\/td><td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc5ec\uae30\uae4c\uc9c0 Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 (CSALTER, CSSCAN)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \ub2e4\uc74c\uc5d0\ub294 US7ASCII, KO16MSWIN949 \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c CSSCAN\uc744 \uc2e4\ud589\ud55c \uacb0\uacfc\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Werfen wir einen Blick auf die von Oracle empfohlene Zeichensatzkonvertierungsmethode. Sie k\u00f6nnen \u00fcberpr\u00fcfen, wie CSALTER und seine Einschr\u00e4nkungen verwendet werden, wie CSSCAN und seine Ausf\u00fchrungsreihenfolge, die Ausf\u00fchrungsergebnisdatei und die DDL verwendet werden, die die CSSCAN-Ausf\u00fchrungsergebnis-Speichertabelle erstellt. Dies ist eine Fortsetzung des vorherigen Artikels. Oracle-Zeichensatzkonvertierung(4): 4.Testumgebung...<\/p>","protected":false},"author":1,"featured_media":11941,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[252,253,242,248,249],"class_list":["post-11940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-csalter","tag-csscan","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(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. CSALTER \uc0ac\uc6a9 \ubc29\ubc95\uacfc \ud55c\uacc4\uc810, CSSCAN \uc0ac\uc6a9 \ubc29\ubc95\uacfc \uc2e4\ud589 \uc21c\uc11c, \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c, CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table\uc744 \uc0dd\uc131\ud558\ub294 DDL\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\/de\/oracle-character-set-migration-5-oracle-recommendation\/\" \/>\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(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. CSALTER \uc0ac\uc6a9 \ubc29\ubc95\uacfc \ud55c\uacc4\uc810, CSSCAN \uc0ac\uc6a9 \ubc29\ubc95\uacfc \uc2e4\ud589 \uc21c\uc11c, \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c, CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table\uc744 \uc0dd\uc131\ud558\ub294 DDL\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/de\/oracle-character-set-migration-5-oracle-recommendation\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T02:40:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:04:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\" \/>\n\t<meta property=\"og:image:width\" content=\"739\" \/>\n\t<meta property=\"og:image:height\" content=\"817\" \/>\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=\"6\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-5-oracle-recommendation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95\",\"datePublished\":\"2022-10-03T02:40:51+00:00\",\"dateModified\":\"2022-10-04T15:04:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/\"},\"wordCount\":431,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\",\"keywords\":[\"CSALTER\",\"CSSCAN\",\"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-5-oracle-recommendation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/\",\"url\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\",\"datePublished\":\"2022-10-03T02:40:51+00:00\",\"dateModified\":\"2022-10-04T15:04:30+00:00\",\"description\":\"Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. CSALTER \uc0ac\uc6a9 \ubc29\ubc95\uacfc \ud55c\uacc4\uc810, CSSCAN \uc0ac\uc6a9 \ubc29\ubc95\uacfc \uc2e4\ud589 \uc21c\uc11c, \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c, CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table\uc744 \uc0dd\uc131\ud558\ub294 DDL\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png\",\"width\":739,\"height\":817},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95\"}]},{\"@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 (5): 5. Von Oracle empfohlene Methode \u2013 Produktivit\u00e4tskompetenz","description":"Werfen wir einen Blick auf die von Oracle empfohlene Zeichensatzkonvertierungsmethode. Sie k\u00f6nnen \u00fcberpr\u00fcfen, wie CSALTER und seine Einschr\u00e4nkungen verwendet werden, wie CSSCAN und seine Ausf\u00fchrungsreihenfolge, die Ausf\u00fchrungsergebnisdatei und die DDL verwendet werden, die die CSSCAN-Ausf\u00fchrungsergebnis-Speichertabelle erstellt.","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-5-oracle-recommendation\/","og_locale":"de_DE","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","og_description":"Oracle \uad8c\uc7a5 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. CSALTER \uc0ac\uc6a9 \ubc29\ubc95\uacfc \ud55c\uacc4\uc810, CSSCAN \uc0ac\uc6a9 \ubc29\ubc95\uacfc \uc2e4\ud589 \uc21c\uc11c, \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c, CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc800\uc7a5 Table\uc744 \uc0dd\uc131\ud558\ub294 DDL\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/de\/oracle-character-set-migration-5-oracle-recommendation\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T02:40:51+00:00","article_modified_time":"2022-10-04T15:04:30+00:00","og_image":[{"width":739,"height":817,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95","datePublished":"2022-10-03T02:40:51+00:00","dateModified":"2022-10-04T15:04:30+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/"},"wordCount":431,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png","keywords":["CSALTER","CSSCAN","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-5-oracle-recommendation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/","name":"Oracle-Zeichensatzkonvertierung (5): 5. Von Oracle empfohlene Methode \u2013 Produktivit\u00e4tskompetenz","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png","datePublished":"2022-10-03T02:40:51+00:00","dateModified":"2022-10-04T15:04:30+00:00","description":"Werfen wir einen Blick auf die von Oracle empfohlene Zeichensatzkonvertierungsmethode. Sie k\u00f6nnen \u00fcberpr\u00fcfen, wie CSALTER und seine Einschr\u00e4nkungen verwendet werden, wie CSSCAN und seine Ausf\u00fchrungsreihenfolge, die Ausf\u00fchrungsergebnisdatei und die DDL verwendet werden, die die CSSCAN-Ausf\u00fchrungsergebnis-Speichertabelle erstellt.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-85.png","width":739,"height":817},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-5-oracle-recommendation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95"}]},{"@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\/11940","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=11940"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11940\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11941"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}