{"id":11943,"date":"2022-10-03T12:35:23","date_gmt":"2022-10-03T03:35:23","guid":{"rendered":"https:\/\/prodskill.com\/?p=11943"},"modified":"2022-10-05T00:05:36","modified_gmt":"2022-10-04T15:05:36","slug":"oracle-character-set-migration-6-us7ascii-csscan-result","status":"publish","type":"post","link":"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/","title":{"rendered":"Oracle \u5b57\u7b26\u96c6\u8f6c\u6362\uff086\uff09\uff1a5.3\u3002 US7ASCII\u73af\u5883CSSCAN\u6267\u884c\u7ed3\u679c"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png\" alt=\"\" class=\"wp-image-11945\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png 800w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-300x169.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-768x432.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited-48x27.png 48w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \ub97c \uc0b4\ud3b4\ubcf8\ub2e4. schema \uc0dd\uc131, directory \uc0dd\uc131, csscan \uc2e4\ud589 \uacb0\uacfc \ud30c\uc77c scan.txt, scan.out, scan.err \ub0b4\uc6a9, \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5\uc5d0 \ub300\ud55c \ub0b4\uc6a9\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-5-oracle-recommendation\/\">Oracle Character Set \ubcc0\ud658(5): 5. Oracle \uad8c\uc7a5 \ubc29\ubc95<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#53_US7ASCII_%ED%99%98%EA%B2%BD_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC\" >5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#531_schema_%EC%83%9D%EC%84%B1\" >5.3.1. schema \uc0dd\uc131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#532_directory_%EC%83%9D%EC%84%B1\" >5.3.2. directory \uc0dd\uc131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#533_csscan_%EC%8B%A4%ED%96%89\" >5.3.3. csscan \uc2e4\ud589<\/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\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#534_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scantxt%EA%B2%B0%EA%B3%BC_%EC%9A%94%EC%95%BD_%EB%B3%B4%EA%B3%A0%EC%84%9C\" >5.3.4. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.txt(\uacb0\uacfc&nbsp;\uc694\uc57d&nbsp;\ubcf4\uace0\uc11c)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#535_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scanoutscan_%EB%8C%80%EC%83%81_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A0%95%EB%B3%B4\" >5.3.5. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.out(scan&nbsp;\ub300\uc0c1&nbsp;\ud14c\uc774\ube14&nbsp;\uc815\ubcf4)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#536_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scanerr%EC%98%A4%EB%A5%98_%EC%83%81%EC%84%B8_%EB%82%B4%EC%97%AD\" >5.3.6. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.err(\uc624\ub958&nbsp;\uc0c1\uc138&nbsp;\ub0b4\uc5ed)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/#537_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC_Table_%EB%B0%B1%EC%97%85\" >5.3.7. CSSCAN \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"5.3._US7ASCII_\ud658\uacbd_CSSCAN_\uc2e4\ud589_\uacb0\uacfc\"><span class=\"ez-toc-section\" id=\"53_US7ASCII_%ED%99%98%EA%B2%BD_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC\"><\/span>5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.1._schema_\uc0dd\uc131\"><span class=\"ez-toc-section\" id=\"531_schema_%EC%83%9D%EC%84%B1\"><\/span>5.3.1. schema \uc0dd\uc131<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>US7ASCII instance\uc5d0 \uc544\ub798 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec csscan \uc2e4\ud589\uc744 \uc704\ud55c schema\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- US7ASCII\nsqlplus sys\/________@oraus7 as sysdba\n@%ORACLE_HOME%\\rdbms\\admin\\csminst.sql\nsqlplus sys\/________@oraus7 as sysdba\nALTER USER CSMIG DEFAULT TABLESPACE USERS;\nEXIT<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>3\ud589: csminst.sql\uc744 \uc2e4\ud589\ud558\uc5ec csmig user(schema)\uc640 csscan \uc2e4\ud589\uc5d0 \ud544\uc694\ud55c \ud14c\uc774\ube14\ub4f1\uc758 \uac1d\uccb4\ub97c \uc0dd\uc131\ud55c\ub2e4. \uc774\ub54c csmig user\uc758 \uae30\ubcf8 tablespace\ub294 system\uc73c\ub85c \uc9c0\uc815\ub41c\ub2e4.<\/li><li>5\ud589: csmig user\uc758 \uae30\ubcf8 tablespace\ub97c users\ub85c \ubcc0\uacbd\ud55c\ub2e4. users\uac00 \uc544\ub2cc \uc800\uc7a5\uacf5\uac04\uc774 \ucda9\ubd84\ud55c \ub2e4\ub978 tablespace\ub85c \ubcc0\uacbd\ud574\ub3c4 \ub41c\ub2e4.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.2._directory_\uc0dd\uc131\"><span class=\"ez-toc-section\" id=\"532_directory_%EC%83%9D%EC%84%B1\"><\/span>5.3.2. directory \uc0dd\uc131<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>csscan \uc2e4\ud589\uacb0\uacfc\ub97c \uc800\uc7a5\ud560 directory\ub97c \uc0dd\uc131\ud558\uace0, \ud574\ub2f9 directory\ub85c \uc774\ub3d9\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mkdir D:\\Temp\\csscan\\US7ASCII\ncd D:\\Temp\\csscan\\US7ASCII<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.3._csscan_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"533_csscan_%EC%8B%A4%ED%96%89\"><\/span>5.3.3. csscan \uc2e4\ud589<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Windows \uba85\ub839 \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c csscan\uc744 \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">csscan \\\"sys\/________@oraus7 as sysdba\\\" full=y tochar=AL32UTF8<\/pre>\n\n\n\n<p>parameter\ub294 \ub450 \uac1c\ub97c \uc9c0\uc815\ud558\uc600\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>full: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \ub300\uc0c1\uc73c\ub85c scan\ud558\ub3c4\ub85d Y \uc9c0\uc815<ul><li>\ucc38\uace0\ub85c, user parameter\ub85c scan \ub300\uc0c1 user\ub97c \uc9c0\uc815\ud558\uac70\ub098 table, column parameter\ub85c scan \ub300\uc0c1\uc744 \uc0c1\uc138\ud558\uac8c \uc9c0\uc815\ud560 \uc218 \uc788\uc74c<\/li><\/ul><\/li><li>tochar: \ubcc0\ud658\ud560 \ubaa9\ud45c character set\uc778 AL32UTF8 \uc9c0\uc815 (CHAR, VARCHAR2, CLOB, LONG type scan)<ul><li>\ucc38\uace0\ub85c, NCHAR, NVARCHAR2, NCLOB type\uc744 scan\ud558\ub824\uba74 tonchar parameter \uc9c0\uc815 \ud544\uc694\ud568<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.4._csscan_\uc2e4\ud589\uacb0\uacfc_\ud655\uc778-scan.txt(\uacb0\uacfc_\uc694\uc57d_\ubcf4\uace0\uc11c)\"><span class=\"ez-toc-section\" id=\"534_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scantxt%EA%B2%B0%EA%B3%BC_%EC%9A%94%EC%95%BD_%EB%B3%B4%EA%B3%A0%EC%84%9C\"><\/span>5.3.4. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.txt(\uacb0\uacfc&nbsp;\uc694\uc57d&nbsp;\ubcf4\uace0\uc11c)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>US7ASCII \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c scan.txt\uc758 \uc804\uccb4 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Database Scan Summary Report\n\nTime Started  : 2014-05-07 19:41:34\nTime Completed: 2014-05-07 19:42:28\n\nProcess ID         Time Started       Time Completed\n---------- -------------------- --------------------\n\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b1  2014-05-07 19:41:48  2014-05-07 19:42:27\n---------- -------------------- --------------------\n\n[Database Size]\n\nTablespace                           Used            Free           Total       Expansion\n------------------------- --------------- --------------- --------------- ---------------\nSYSTEM                            577.81M         122.19M         700.00M           2.25M\nSYSAUX                            354.56M         245.44M         600.00M          13.09M\nUNDOTBS1                           14.75M         455.25M         470.00M            .00K\nTEMP                                 .00K            .00K            .00K            .00K\nUSERS                               1.81M           3.19M           5.00M         158.00K\n------------------------- --------------- --------------- --------------- ---------------\nTotal                             948.94M         826.06M       1,775.00M          15.49M\n\nThe size of the largest CLOB is 1625114 bytes\n\n[Database Scan Parameters]\n\nParameter                      Value                                           \n------------------------------ ------------------------------------------------\nCSSCAN Version                 v2.1                                            \nInstance Name                  oraus7                                          \nDatabase Version               11.2.0.1.0                                      \nScan type                      Full database                                   \nScan CHAR data?                YES                                             \nDatabase character set         US7ASCII                                        \nFROMCHAR                       US7ASCII                                        \nTOCHAR                         AL32UTF8                                        \nScan NCHAR data?               NO                                              \nArray fetch buffer size        1024000                                         \nNumber of processes            1                                               \nCapture convertible data?      NO                                              \n------------------------------ ------------------------------------------------\n\n[Scan Summary]\n\nSome character type data in the data dictionary are not convertible to the new character set\nSome character type application data are not convertible to the new character set\n\n[Data Dictionary Conversion Summary]\n\nData Dictionary Tables:\n\nDatatype                    Changeless      Convertible       Truncation            Lossy\n--------------------- ---------------- ---------------- ---------------- ----------------\nVARCHAR2                     2,686,869                0                0               11\nCHAR                             2,834                0                0                0\nLONG                           189,691                0                0                0\nCLOB                            45,948            2,244                0               32\nVARRAY                          39,205                0                0                0\n--------------------- ---------------- ---------------- ---------------- ----------------\nTotal                        2,964,547            2,244                0               43\nTotal in percentage             99.923%           0.076%           0.000%           0.001%\n\nThe data dictionary can not be safely migrated using the CSALTER script\n\nXML CSX Dictionary Tables:\n\nDatatype                    Changeless      Convertible       Truncation            Lossy\n--------------------- ---------------- ---------------- ---------------- ----------------\nVARCHAR2                           493                0                0                0\nCHAR                                 0                0                0                0\nLONG                                 0                0                0                0\nCLOB                                 0                0                0                0\nVARRAY                               0                0                0                0\n--------------------- ---------------- ---------------- ---------------- ----------------\nTotal                              493                0                0                0\nTotal in percentage            100.000%           0.000%           0.000%           0.000%\n\n[Application Data Conversion Summary]\n\nDatatype                    Changeless      Convertible       Truncation            Lossy\n--------------------- ---------------- ---------------- ---------------- ----------------\nVARCHAR2                     2,580,031                0            4,507           14,855\nCHAR                                 0                0                0                0\nLONG                                 0                0                0                0\nCLOB                            29,628            8,291                0                1\nVARRAY                               0                0                0                0\n--------------------- ---------------- ---------------- ---------------- ----------------\nTotal                        2,609,659            8,291            4,507           14,856\nTotal in percentage             99.121%           0.315%           0.171%           0.564%\n\n[Distribution of Convertible, Truncated and Lossy Data by Table]\n\nData Dictionary Tables:\n\nUSER.TABLE                                              Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\nMDSYS.SDO_COORD_OP_PARAM_VALS                                   200                0                0\nMDSYS.SDO_STYLES_TABLE                                           78                0                0\nMDSYS.SDO_XML_SCHEMAS                                             3                0                0\nORDDATA.ORDDCM_CT_PRED_OPRD                                      51                0                0\nORDDATA.ORDDCM_DOCS                                               9                0                0\nORDDATA.ORDDCM_MAPPING_DOCS                                       1                0                0\nSYS.COM$                                                          0                0               11\nSYS.METASTYLESHEET                                              178                0                0\nSYS.RULE$                                                         1                0                0\nSYS.SCHEDULER$_EVENT_LOG                                         38                0                0\nSYS.WRH$_SQLTEXT                                                712                0               32\nSYS.WRH$_SQL_PLAN                                               716                0                0\nSYS.WRI$_ADV_DIRECTIVE_META                                       5                0                0\nSYS.WRI$_ADV_OBJECTS                                              5                0                0\nSYS.WRI$_DBU_FEATURE_METADATA                                   188                0                0\nSYS.WRI$_DBU_FEATURE_USAGE                                       10                0                0\nSYS.WRI$_DBU_HWM_METADATA                                        20                0                0\nSYS.WRI$_REPT_FILES                                              27                0                0\nXDB.XDB$DXPTAB                                                    2                0                0\n-------------------------------------------------- ---------------- ---------------- ----------------\n\nXML CSX Dictionary Tables:\n\nUSER.TABLE                                              Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\n-------------------------------------------------- ---------------- ---------------- ----------------\n\nApplication Data:\n\nUSER.TABLE                                              Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\nAPEX_030200.WWV_FLOW_BANNER                                      10                0                0\nAPEX_030200.WWV_FLOW_BUTTON_TEMPLATES                            12                0                0\nAPEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS                          19                0                0\nAPEX_030200.WWV_FLOW_FLASH_CHART_SERIES                           5                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES                             298                0                0\nAPEX_030200.WWV_FLOW_PAGE_GENERIC_ATTR                           44                0                0\nAPEX_030200.WWV_FLOW_PAGE_PLUGS                               3,241                0                0\nAPEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES                        254                0                0\nAPEX_030200.WWV_FLOW_PROCESSING                                  45                0                0\nAPEX_030200.WWV_FLOW_ROW_TEMPLATES                               66                0                0\nAPEX_030200.WWV_FLOW_SHORTCUTS                                   39                0                0\nAPEX_030200.WWV_FLOW_STEPS                                    1,797                0                0\nAPEX_030200.WWV_FLOW_STEP_PROCESSING                          2,239                0                0\nAPEX_030200.WWV_FLOW_TEMPLATES                                  192                0                0\nAPEX_030200.WWV_FLOW_WORKSHEETS                                  30                0                0\nLEG.SUB_MON_STAT                                                  0            4,507           14,854\nLEG.Z_TEST                                                        0                0                2\n-------------------------------------------------- ---------------- ---------------- ----------------\n\n[Distribution of Convertible, Truncated and Lossy Data by Column]\n\nData Dictionary Tables:\n\nUSER.TABLE|COLUMN                                       Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\nMDSYS.SDO_COORD_OP_PARAM_VALS|PARAM_VALUE_FILE                  200                0                0\nMDSYS.SDO_STYLES_TABLE|DEFINITION                                78                0                0\nMDSYS.SDO_XML_SCHEMAS|XMLSCHEMA                                   3                0                0\nORDDATA.ORDDCM_CT_PRED_OPRD|SYS_NC00004$                         51                0                0\nORDDATA.ORDDCM_DOCS|SYS_NC00005$                                  9                0                0\nORDDATA.ORDDCM_MAPPING_DOCS|SYS_NC00007$                          1                0                0\nSYS.COM$|COMMENT$                                                 0                0               11\nSYS.METASTYLESHEET|STYLESHEET                                   178                0                0\nSYS.RULE$|CONDITION                                               1                0                0\nSYS.SCHEDULER$_EVENT_LOG|ADDITIONAL_INFO                         38                0                0\nSYS.WRH$_SQLTEXT|SQL_TEXT                                       712                0               32\nSYS.WRH$_SQL_PLAN|OTHER_XML                                     716                0                0\nSYS.WRI$_ADV_DIRECTIVE_META|DATA                                  5                0                0\nSYS.WRI$_ADV_OBJECTS|ATTR4                                        5                0                0\nSYS.WRI$_DBU_FEATURE_METADATA|INST_CHK_LOGIC                     21                0                0\nSYS.WRI$_DBU_FEATURE_METADATA|USG_DET_LOGIC                     167                0                0\nSYS.WRI$_DBU_FEATURE_USAGE|FEATURE_INFO                          10                0                0\nSYS.WRI$_DBU_HWM_METADATA|LOGIC                                  20                0                0\nSYS.WRI$_REPT_FILES|SYS_NC00005$                                 27                0                0\nXDB.XDB$DXPTAB|SYS_NC00006$                                       2                0                0\n-------------------------------------------------- ---------------- ---------------- ----------------\n\nXML CSX Dictionary Tables:\n\nUSER.TABLE|COLUMN                                       Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\n-------------------------------------------------- ---------------- ---------------- ----------------\n\nApplication Data:\n\nUSER.TABLE|COLUMN                                       Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\nAPEX_030200.WWV_FLOW_BANNER|BANNER                               10                0                0\nAPEX_030200.WWV_FLOW_BUTTON_TEMPLATES|TEMPLATE                   12                0                0\nAPEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS|AUTH_FUNC                 8                0                0\nAPEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS|PAGE_SENT                10                0                0\nAPEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS|POST_AUTH                 1                0                0\nAPEX_030200.WWV_FLOW_FLASH_CHART_SERIES|SERIES_QU                 5                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|ITEM_TEMPLATE                20                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|ITEM_TEMPLATE                20                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|LIST_TEMPLATE               105                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|LIST_TEMPLATE               105                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|SUB_LIST_ITEM                12                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|SUB_LIST_ITEM                12                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|SUB_TEMPLATE_                12                0                0\nAPEX_030200.WWV_FLOW_LIST_TEMPLATES|SUB_TEMPLATE_                12                0                0\nAPEX_030200.WWV_FLOW_PAGE_GENERIC_ATTR|ATTRIBUTE_                44                0                0\nAPEX_030200.WWV_FLOW_PAGE_PLUGS|PLUG_SOURCE                   3,241                0                0\nAPEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES|TEMPLATE               166                0                0\nAPEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES|TEMPLATE                88                0                0\nAPEX_030200.WWV_FLOW_PROCESSING|PROCESS_SQL_CLOB                 45                0                0\nAPEX_030200.WWV_FLOW_ROW_TEMPLATES|ROW_TEMPLATE1                 54                0                0\nAPEX_030200.WWV_FLOW_ROW_TEMPLATES|ROW_TEMPLATE2                 10                0                0\nAPEX_030200.WWV_FLOW_ROW_TEMPLATES|ROW_TEMPLATE3                  2                0                0\nAPEX_030200.WWV_FLOW_SHORTCUTS|SHORTCUT                          39                0                0\nAPEX_030200.WWV_FLOW_STEPS|HELP_TEXT                          1,514                0                0\nAPEX_030200.WWV_FLOW_STEPS|HTML_PAGE_HEADER                     283                0                0\nAPEX_030200.WWV_FLOW_STEP_PROCESSING|PROCESS_SQL_             2,239                0                0\nAPEX_030200.WWV_FLOW_TEMPLATES|BOX                               64                0                0\nAPEX_030200.WWV_FLOW_TEMPLATES|FOOTER_TEMPLATE                   64                0                0\nAPEX_030200.WWV_FLOW_TEMPLATES|HEADER_TEMPLATE                   64                0                0\nAPEX_030200.WWV_FLOW_WORKSHEETS|SQL_QUERY                        30                0                0\nLEG.SUB_MON_STAT|COMMT                                            0                1                1\nLEG.SUB_MON_STAT|LINE_NUM                                         0            3,238            7,426\nLEG.SUB_MON_STAT|REF_DES                                          0                0                1\nLEG.SUB_MON_STAT|SUB_STA_NM                                       0            1,268            7,426\nLEG.Z_TEST|VAL                                                    0                0                2\n-------------------------------------------------- ---------------- ---------------- ----------------\n\n[Indexes to be Rebuilt]\n\nUSER.INDEX on USER.TABLE(COLUMN)                                                         \n-----------------------------------------------------------------------------------------\nAPEX_030200.WWV_FLOW_WORKSHEETS_UNQ_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(SYS_NC00078$)\nAPEX_030200.WWV_FLOW_WORKSHEETS_UNQ_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(SYS_NC00079$)\nAPEX_030200.WWV_FLOW_WORKSHEETS_UNQ_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(SYS_NC00080$)\nAPEX_030200.WWV_FLOW_WORKSHEETS_UNQ_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(SYS_NC00081$)\nAPEX_030200.WWV_FLOW_WS_UNQ_ALIAS_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(SYS_NC00082$)\nAPEX_030200.WWV_FLOW_WS_UNQ_ALIAS_IDX on APEX_030200.WWV_FLOW_WORKSHEETS(ALIAS)\n-----------------------------------------------------------------------------------------<\/pre>\n\n\n\n<p>\uc774 \uc911\uc5d0\uc11c &#8220;Application Data Conversion Summary&#8221; \ub0b4\uc6a9\uc774 Oracle System Data\uac00 \uc544\ub2cc \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ud55c Data\uc5d0 type\ubcc4\ub85c scan\ud55c \ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">[Application Data Conversion Summary]\n\nDatatype                    Changeless      Convertible       Truncation            Lossy\n--------------------- ---------------- ---------------- ---------------- ----------------\nVARCHAR2                     2,580,031                0            4,507           14,855\nCHAR                                 0                0                0                0\nLONG                                 0                0                0                0\nCLOB                            29,628            8,291                0                1\nVARRAY                               0                0                0                0\n--------------------- ---------------- ---------------- ---------------- ----------------\nTotal                        2,609,659            8,291            4,507           14,856\nTotal in percentage             99.121%           0.315%           0.171%           0.564%<\/pre>\n\n\n\n<p>\uc704 \ub0b4\uc6a9\uc744 \ud574\uc11d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>VARCHAR2 type\uc5d0 \ub300\ud574\uc11c AL32UTF8\ub85c \ubcc0\uacbd \uc2dc 2,580,031\uac1c\uc758 value\ub294 \ubcc0\uacbd \uc5c6\uc774(Changeless) \uadf8\ub300\ub85c \uc804\ud658\ub420 \uc218 \uc788\uace0, 4,507 \uac1c\uc758 value\uac00 \uc798\ub824(Truncation)\uc9c0\uba70, 14,855\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><li>CLOB type\uc5d0 \ub300\ud574\uc11c AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, 29,628\uac1c\uc758 value\ub294 \ubcc0\uacbd \uc5c6\uc774(Changeless) \uadf8\ub300\ub85c \uc804\ud658\ub420 \uc218 \uc788\uace0, 8,291\uac1c\uc758 value\ub294 \ubcc0\ud658\uac00\ub2a5(Convertible)\ud558\uba70, 1\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><li>\uadf8\uc678 CHAR, LONG, VARRAY type\uc758 \ub370\uc774\ud130\ub294 \ubcc0\ud658 \ub300\uc0c1\uc774 \uc5c6\uc74c<\/li><\/ul>\n\n\n\n<p>\uc704 \ub0b4\uc6a9\uc5d0\uc11c Changeless, Convertible, Truncation, Lossy\uc5d0 \ub300\ud55c \uc124\uba85\uc740 \uc774\uc804 \uae00\uc5d0 \uc791\uc131\ud574 \ub450\uc5c8\uace0, \uc544\ub798\uc5d0 \ud55c\ubc88 \ub354 \ud45c\uae30\ud574 \ub454\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-5-oracle-recommendation\/#52_CSSCAN_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\">Oracle Character Set \ubcc0\ud658(5) &#8211; 5.2. CSSCAN \uc0ac\uc6a9 \ubc29\ubc95<\/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; 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; 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<p>&#8220;Distribution&nbsp;of&nbsp;Convertible,&nbsp;Truncated&nbsp;and&nbsp;Lossy&nbsp;Data&nbsp;by&nbsp;Table&#8221;, &#8220;Distribution of Convertible, Truncated and Lossy Data by Column&#8221; \ub0b4\uc6a9\uc740 \uac01 \ud14c\uc774\ube14\uacfc \uceec\ub7fc\ubcc4\ub85c scan\ud55c \uacb0\uacfc\uc774\ub2e4.<\/p>\n\n\n\n<p>\uc544\ub798\uc5d0 \ud30c\uc77c\uc758 \uc77c\ubd80 \ub0b4\uc6a9\uc744 \ubc1c\ucdcc\ud574 \ub454\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">[Distribution of Convertible, Truncated and Lossy Data by Table]\n\n...\nApplication Data:\n\nUSER.TABLE                                              Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\n...\nLEG.SUB_MON_STAT                                                  0            4,507           14,854\nLEG.Z_TEST                                                        0                0                2\n-------------------------------------------------- ---------------- ---------------- ----------------\n\n[Distribution of Convertible, Truncated and Lossy Data by Column]\n\n...\nApplication Data:\n\nUSER.TABLE|COLUMN                                       Convertible       Truncation            Lossy\n-------------------------------------------------- ---------------- ---------------- ----------------\n...\nLEG.SUB_MON_STAT|COMMT                                            0                1                1\nLEG.SUB_MON_STAT|LINE_NUM                                         0            3,238            7,426\nLEG.SUB_MON_STAT|REF_DES                                          0                0                1\nLEG.SUB_MON_STAT|SUB_STA_NM                                       0            1,268            7,426\nLEG.Z_TEST|VAL                                                    0                0                2\n-------------------------------------------------- ---------------- ---------------- ----------------<\/pre>\n\n\n\n<p>\uc704&nbsp;\ub0b4\uc6a9\uc744&nbsp;\ud574\uc11d\ud558\uba74&nbsp;\ub2e4\uc74c\uacfc&nbsp;\uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>LEG.SUB_MON_STAT \ud14c\uc774\ube14\uc740 AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, 4,507\uac1c\uc758 value\uac00 \uc798\ub824(Truncation)\uc9c0\uba70, 14,854\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568. \uac01 \uceec\ub7fc\ubcc4\ub85c \ub2e4\uc74c\uacfc \uac19\uc74c<ul><li>COMMT: AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, 1\uac1c\uc758 value\uac00 \uc798\ub824(Truncation)\uc9c0\uba70, 1\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><li>LINE_NUM: AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, 3,238\uac1c\uc758 value\uac00 \uc798\ub824(Truncation)\uc9c0\uba70, 7,426\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><li>REF_DES: AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, 1\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><li>SUB_STA_NM: AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, 1,268\uac1c\uc758 value\uac00 \uc798\ub824(Truncation)\uc9c0\uba70, 7,426\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568<\/li><\/ul><\/li><li>LEG.Z_TEST \ud14c\uc774\ube14\uc740 AL32UTF8\ub85c \ubcc0\uacbd \uc2dc, \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\ub294 value\ub294 \uc5c6\uace0, \uc798\ub824(Truncation)\uc9c0\ub294 value\ub3c4 \uc5c6\uc73c\uba70, 2\uac1c\uc758 value\ub294 \uc190\uc2e4\/\uae68\uc9d0(Lossy)\uc774 \ubc1c\uc0dd\ud568. VAL \uceec\ub7fc\uc774 \uc774\uc5d0 \ud574\ub2f9\ud568.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.5._csscan_\uc2e4\ud589\uacb0\uacfc_\ud655\uc778-scan.out(scan_\ub300\uc0c1_\ud14c\uc774\ube14_\uc815\ubcf4)\"><span class=\"ez-toc-section\" id=\"535_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scanoutscan_%EB%8C%80%EC%83%81_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A0%95%EB%B3%B4\"><\/span>5.3.5. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.out(scan&nbsp;\ub300\uc0c1&nbsp;\ud14c\uc774\ube14&nbsp;\uc815\ubcf4)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>scan.out \ud30c\uc77c\uc5d0\uc11c\ub294 scan \ub300\uc0c1 \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on Wed May 7 19:41:28 2014\n\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n\nEnter array fetch buffer size: 1024000 > \nEnter number of scan processes to utilize(1..64): 1 > \nEnumerating tables to scan...\n\n. process 1 scanning SYS.SOURCE$[AAAADfAABAAAAXYAAA]\n. process 1 scanning SYS.TYPE$[AAAAH3AABAAAAzgAAA]\n. process 1 scanning SYS.ATTRIBUTE$[AAAAH3AABAAAAzgAAA]\n. process 1 scanning SYS.PARAMETER$[AAAAH3AABAAAAzgAAA]\n...\n. process 1 scanning MDSYS.SDO_CS_SRS[AAAPR3AACAAAEvwAAA]\n. process 1 scanning SYS.HISTGRM$[AAAAGkAABAAAAoAAAA]\n. process 1 scanning XDB.XDBACL_PATH_TAB[AAAN7uAACAAAED4AAA]\nORA-30967: operation directly on the Path Table is disallowed\n\nCSS-00144: failed to scan table XDB.XDBACL_PATH_TAB\n\n...\n. process 1 scanning XDB.XDB$RESOURCE[AAANy9AACAAADj4AAA]\n. process 1 scanning APEX_030200.WWV_FLOW_STEP_ITEMS[AAAPrtAACAAAGBgAAA]\n. process 1 scanning SYS.VIEW$[AAAABFAABAAAAJwAAA]\n...\n. process 1 scanning LEG.SUB_MON_STAT[AAAQZLAAEAAAACIAAA]\n...\n\nCreating Database Scan Summary Report...\n\nCreating Individual Exception Report...\n\nScanner terminated successfully.<\/pre>\n\n\n\n<p>\uc5ec\uae30\uc5d0\uc11c\ub294 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>31\ud589: \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0 \uc0dd\uc131\ud574 \ub193\uc740 LEG user\uc758 SUB_MON_STAT \ud14c\uc774\ube14\uc744 scan\ud568<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.6._csscan_\uc2e4\ud589\uacb0\uacfc_\ud655\uc778-scan.err(\uc624\ub958_\uc0c1\uc138_\ub0b4\uc5ed)\"><span class=\"ez-toc-section\" id=\"536_csscan_%EC%8B%A4%ED%96%89%EA%B2%B0%EA%B3%BC_%ED%99%95%EC%9D%B8-scanerr%EC%98%A4%EB%A5%98_%EC%83%81%EC%84%B8_%EB%82%B4%EC%97%AD\"><\/span>5.3.6. csscan \uc2e4\ud589\uacb0\uacfc \ud655\uc778-scan.err(\uc624\ub958&nbsp;\uc0c1\uc138&nbsp;\ub0b4\uc5ed)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>scan.err \ud30c\uc77c\uc5d0\uc11c\ub294 \uac01 \ud14c\uc774\ube14, \uceec\ub7fc\uc758 character set \ubcc0\ud658 \uc624\ub958 \ub0b4\uc5ed\uc744 \uc0c1\uc138\ud558\uac8c \uc0b4\ud3b4\ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Database Scan Individual Exception Report\n\n\n[Database Scan Parameters]\n\nParameter                      Value\n------------------------------ ------------------------------------------------\nCSSCAN Version                 v2.1\nInstance Name                  oraus7\nDatabase Version               11.2.0.1.0\nScan type                      Full database\nScan CHAR data?                YES\nDatabase character set         US7ASCII\nFROMCHAR                       US7ASCII\nTOCHAR                         AL32UTF8\nScan NCHAR data?               NO\nArray fetch buffer size        1024000\nNumber of processes            1\nCapture convertible data?      NO\n------------------------------ ------------------------------------------------\n\n[Data Dictionary individual exceptions]\n\nUser  : SYS\nTable : COM$\nColumn: COMMENT$\nType  : VARCHAR2(4000)\nNumber of Exceptions         : 11\nMax Post Conversion Data Size: 381\n\nROWID              Exception Type      Size Cell Data(first 30 bytes)\n------------------ ------------------ ----- ------------------------------\nAAAACIAABAAAQTfABN lossy conversion         \uc0ac\uc6a9\uc6d4\nAAAACIAABAAAQTfABO lossy conversion         \ud638\uc120\uba85\nAAAACIAABAAAQTfABP lossy conversion         \uc9c0\ud558\ucca0\uc5ed\ucf54\ub4dc\nAAAACIAABAAAQTfABQ lossy conversion         \uc9c0\ud558\ucca0\uc5ed\uba85\nAAAACIAABAAAQTfABR lossy conversion         \uc2b9\ucc28\uc778\uc6d0\uc218\nAAAACIAABAAAQTfABS lossy conversion         \ud558\ucc28\uc778\uc6d0\uc218\nAAAACIAABAAAQTfABT lossy conversion         \uc791\uc5c5\uc77c\uc790\nAAAACIAABAAAQTfABU lossy conversion         \ube44\uace0\nAAAACIAABAAAQTfABV lossy conversion         \ucc38\uc870\uc124\uba85\nAAAACIAABAAAQTfABW lossy conversion         \ucc38\uc870\uc774\ubbf8\uc9c0\nAAAACIAABAAAQTfABX lossy conversion         \uc9c0\ud558\ucca0\uc5ed\ubcc4\uc2b9\ud558\ucc28\uc778\uc6d0\n------------------ ------------------ ----- ------------------------------\n\n\n[Application data individual exceptions]\n\nUser  : LEG\nTable : SUB_MON_STAT\nColumn: SUB_STA_NM\nType  : VARCHAR2(20)\nNumber of Exceptions         : 7426\nMax Post Conversion Data Size: 54\n\nROWID              Exception Type      Size Cell Data(first 30 bytes)\n------------------ ------------------ ----- ------------------------------\nAAAQZLAAEAAAAC+AA+ lossy conversion         \uc6a9\ubb38\nAAAQZLAAEAAAAC+AA\/ lossy conversion         \uc11c\uc6b8\uc5ed\nAAAQZLAAEAAAAC+AA0 lossy conversion         \ub3c4\uc2ec\nAAAQZLAAEAAAAC+AA1 lossy conversion         \ud314\ub2f9\nAAAQZLAAEAAAAC+AAH lossy conversion         \uc6d4\uacf6\nAAAQZLAAEAAAAC+AAI lossy conversion         \uc18c\ub798\ud3ec\uad6c\nAAAQZLAAEAAAAC+AAI exceed column size    24 \uc18c\ub798\ud3ec\uad6c\nAAAQZLAAEAAAAC+AAJ lossy conversion         \uc778\ucc9c\ub17c\ud604\nAAAQZLAAEAAAAC+AAJ exceed column size    24 \uc778\ucc9c\ub17c\ud604\n...\n\n------------------ ------------------ ----- ------------------------------\n\nUser  : LEG\nTable : SUB_MON_STAT\nColumn: COMMT\nType  : VARCHAR2(4000)\nNumber of Exceptions         : 1\nMax Post Conversion Data Size: 9000\n\nROWID              Exception Type      Size Cell Data(first 30 bytes)\n------------------ ------------------ ----- ------------------------------\nAAAQZLAAEAAAACOAAA lossy conversion         \uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\nAAAQZLAAEAAAACOAAA exceed column size  9000 \uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\n------------------ ------------------ ----- ------------------------------\n\nUser  : LEG\nTable : SUB_MON_STAT\nColumn: LINE_NUM\nType  : VARCHAR2(14)\nNumber of Exceptions         : 7426\nMax Post Conversion Data Size: 38\n\nROWID              Exception Type      Size Cell Data(first 30 bytes)\n------------------ ------------------ ----- ------------------------------\nAAAQZLAAEAAAAC+AA+ exceed column size    18 \uc911\uc559\uc120\nAAAQZLAAEAAAAC+AA+ lossy conversion         \uc911\uc559\uc120\nAAAQZLAAEAAAAC+AA\/ lossy conversion         1\ud638\uc120\nAAAQZLAAEAAAAC+AA0 exceed column size    18 \uc911\uc559\uc120\nAAAQZLAAEAAAAC+AA0 lossy conversion         \uc911\uc559\uc120\nAAAQZLAAEAAAAC+AA1 exceed column size    18 \uc911\uc559\uc120\n...\n------------------ ------------------ ----- ------------------------------\n\nUser  : LEG\nTable : SUB_MON_STAT\nColumn: REF_DES\nType  : CLOB\nNumber of Exceptions         : 1\nMax Post Conversion Data Size: 3000\n\nROWID              Exception Type      Size Cell Data(first 30 bytes)\n------------------ ------------------ ----- ------------------------------\nAAAQZLAAEAAAACOAAA lossy conversion         \uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\n------------------ ------------------ ----- ------------------------------<\/pre>\n\n\n\n<p>US7ASCII \ud658\uacbd\uc5d0\uc11c\uc758 CSSCAN \uc2e4\ud589\uacb0\uacfc \ud30c\uc77c\uc740 \uc544\ub798 github repository\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>scan.txt:&nbsp;<a href=\"https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/blob\/main\/US7ASCII\/scan.txt\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle-CharacterSet-Conversion\/scan.txt at main \u00b7 DAToolset\/Oracle-CharacterSet-Conversion (github.com)<\/a><\/li><li>scan.out:&nbsp;<a href=\"https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/blob\/main\/US7ASCII\/scan.out\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle-CharacterSet-Conversion\/scan.out at main \u00b7 DAToolset\/Oracle-CharacterSet-Conversion (github.com)<\/a><\/li><li>scan.err:&nbsp;<a href=\"https:\/\/github.com\/DAToolset\/Oracle-CharacterSet-Conversion\/blob\/main\/US7ASCII\/scan.err\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle-CharacterSet-Conversion\/scan.err at main \u00b7 DAToolset\/Oracle-CharacterSet-Conversion (github.com)<\/a><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5.3.7._CSSCAN_\uc2e4\ud589_\uacb0\uacfc_Table_\ubc31\uc5c5\"><span class=\"ez-toc-section\" id=\"537_CSSCAN_%EC%8B%A4%ED%96%89_%EA%B2%B0%EA%B3%BC_Table_%EB%B0%B1%EC%97%85\"><\/span>5.3.7. CSSCAN \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5<span class=\"ez-toc-section-end\"><\/span><\/h4>\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, 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 \uc2e4\ud589\uacb0\uacfc\ub85c \uc0dd\uc131\ub418\ub294 \ub370\uc774\ud130\uc758 \uc608\uc2dc\ub294 \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 is-style-dots\"\/>\n\n\n\n<p>\uc5ec\uae30\uae4c\uc9c0 US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \ub2e4\uc74c\uc5d0\ub294 KO16MSWIN949 \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c CSSCAN\uc744 \uc2e4\ud589\ud55c \uacb0\uacfc\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u68c0\u67e5US7ASCII \u73af\u5883CSSCAN \u6267\u884c\u7ed3\u679c\u3002\u53ef\u4ee5\u67e5\u770bschema\u521b\u5efa\u3001\u76ee\u5f55\u521b\u5efa\u3001csscan\u6267\u884c\u7ed3\u679c\u6587\u4ef6scan.txt\u3001scan.out\u3001scan.err\u5185\u5bb9\u3001\u6267\u884c\u7ed3\u679c\u8868\u5907\u4efd\u5185\u5bb9\u3002\u8fd9\u662f\u4e0a\u4e00\u7bc7\u6587\u7ae0\u7684\u5ef6\u7eed\u3002 Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u4e94\uff09\uff1a5. Oracle\u63a8\u8350\u65b9\u6cd5...<\/p>","protected":false},"author":1,"featured_media":11945,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[249,252,253,254,242,248],"class_list":["post-11943","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-character-set-conversion","tag-csalter","tag-csscan","tag-us7ascii","tag-oracle","tag-character-set-"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \ub97c \uc0b4\ud3b4\ubcf8\ub2e4. schema \uc0dd\uc131, directory \uc0dd\uc131, csscan \uc2e4\ud589 \uacb0\uacfc \ud30c\uc77c scan.txt, scan.out, scan.err \ub0b4\uc6a9, \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5\uc5d0 \ub300\ud55c \ub0b4\uc6a9\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\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \ub97c \uc0b4\ud3b4\ubcf8\ub2e4. schema \uc0dd\uc131, directory \uc0dd\uc131, csscan \uc2e4\ud589 \uacb0\uacfc \ud30c\uc77c scan.txt, scan.out, scan.err \ub0b4\uc6a9, \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T03:35:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:05:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\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=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 \u5206\" \/>\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-6-us7ascii-csscan-result\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc\",\"datePublished\":\"2022-10-03T03:35:23+00:00\",\"dateModified\":\"2022-10-04T15:05:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/\"},\"wordCount\":397,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/text-thumbnail_us7ascii_csscan-edited.png\",\"keywords\":[\"Character Set Conversion\",\"CSALTER\",\"CSSCAN\",\"US7ASCII\",\"ORACLE\",\"Character Set \ubcc0\ud658\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/text-thumbnail_us7ascii_csscan-edited.png\",\"datePublished\":\"2022-10-03T03:35:23+00:00\",\"dateModified\":\"2022-10-04T15:05:36+00:00\",\"description\":\"US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \ub97c \uc0b4\ud3b4\ubcf8\ub2e4. schema \uc0dd\uc131, directory \uc0dd\uc131, csscan \uc2e4\ud589 \uacb0\uacfc \ud30c\uc77c scan.txt, scan.out, scan.err \ub0b4\uc6a9, \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/text-thumbnail_us7ascii_csscan-edited.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/text-thumbnail_us7ascii_csscan-edited.png\",\"width\":800,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-6-us7ascii-csscan-result\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc\"}]},{\"@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\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\\\/zh\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u516d\uff09\uff1a5.3. US7ASCII\u73af\u5883\u4e0bCSSCAN\u6267\u884c\u7ed3\u679c - \u751f\u4ea7\u529b\u6280\u5de7","description":"\u68c0\u67e5US7ASCII\u73af\u5883CSSCAN\u6267\u884c\u7ed3\u679c\u3002\u53ef\u4ee5\u67e5\u770bSchema\u521b\u5efa\u3001\u76ee\u5f55\u521b\u5efa\u3001csscan\u6267\u884c\u7ed3\u679c\u6587\u4ef6scan.txt\u3001scan.out\u3001scan.err\u5185\u5bb9\u3001\u6267\u884c\u7ed3\u679c\u8868\u5907\u4efd\u5185\u5bb9\u3002","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\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/","og_locale":"zh_CN","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc - \uc0dd\uc0b0\uc131 Skill","og_description":"US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc \ub97c \uc0b4\ud3b4\ubcf8\ub2e4. schema \uc0dd\uc131, directory \uc0dd\uc131, csscan \uc2e4\ud589 \uacb0\uacfc \ud30c\uc77c scan.txt, scan.out, scan.err \ub0b4\uc6a9, \uc2e4\ud589 \uacb0\uacfc Table \ubc31\uc5c5\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-6-us7ascii-csscan-result\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T03:35:23+00:00","article_modified_time":"2022-10-04T15:05:36+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"12 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc","datePublished":"2022-10-03T03:35:23+00:00","dateModified":"2022-10-04T15:05:36+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/"},"wordCount":397,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png","keywords":["Character Set Conversion","CSALTER","CSSCAN","US7ASCII","ORACLE","Character Set \ubcc0\ud658"],"articleSection":["ORACLE"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/","name":"Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u516d\uff09\uff1a5.3. US7ASCII\u73af\u5883\u4e0bCSSCAN\u6267\u884c\u7ed3\u679c - \u751f\u4ea7\u529b\u6280\u5de7","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png","datePublished":"2022-10-03T03:35:23+00:00","dateModified":"2022-10-04T15:05:36+00:00","description":"\u68c0\u67e5US7ASCII\u73af\u5883CSSCAN\u6267\u884c\u7ed3\u679c\u3002\u53ef\u4ee5\u67e5\u770bSchema\u521b\u5efa\u3001\u76ee\u5f55\u521b\u5efa\u3001csscan\u6267\u884c\u7ed3\u679c\u6587\u4ef6scan.txt\u3001scan.out\u3001scan.err\u5185\u5bb9\u3001\u6267\u884c\u7ed3\u679c\u8868\u5907\u4efd\u5185\u5bb9\u3002","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/text-thumbnail_us7ascii_csscan-edited.png","width":800,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-6-us7ascii-csscan-result\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(6): 5.3. US7ASCII \ud658\uacbd CSSCAN \uc2e4\ud589 \uacb0\uacfc"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","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":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@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\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=11943"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11943\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/11945"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=11943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=11943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=11943"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}