oracle的字符集檢查工具CSSCAN(二)

楊奇龍發表於2011-03-14
SCAN.TXT 檔案的內容:
Database Scan Summary Report

Time Started  : 2011-03-14 12:22:16
Time Completed: 2011-03-14 12:22:59

Process ID         Time Started       Time Completed
---------- -------------------- --------------------
         1  2011-03-14 12:22:47  2011-03-14 12:22:58
         2  2011-03-14 12:22:48  2011-03-14 12:22:58
---------- -------------------- --------------------

[Database Size]

Tablespace                           Used            Free           Total       Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM                            750.50M         419.50M       1,170.00M            .00K
SYSAUX                            629.81M          32.06M         661.88M            .00K
UNDOTBS1                           56.31M          23.69M          80.00M            .00K
TEMP                                 .00K            .00K            .00K            .00K
USERS                             508.00M         723.25M       1,231.25M           3.00K
EXAMPLE                            77.69M         222.31M         300.00M            .00K
------------------------- --------------- --------------- --------------- ---------------
Total                           2,022.31M       1,420.81M       3,443.13M           3.00K

[Database Scan Parameters]

Parameter                      Value                                           
------------------------------ ------------------------------------------------
CSSCAN Version                 v2.1                                            
Instance Name                  oracl                                           
Database Version               11.1.0.6.0                                      
Scan type                      User tables                                     
User name                      yang                                            
Scan CHAR data?                YES                                             
Database character set         ZHS16GBK                                        
FROMCHAR                       ZHS16GBK                                        
TOCHAR                         al32utf8                                        
Scan NCHAR data?               NO                                              
Array fetch buffer size        104000                                          
Number of processes            2                                               
Capture convertible data?      NO                                              
------------------------------ ------------------------------------------------

[Scan Summary]

Some character type application data are not convertible to the new character set

[Data Dictionary Conversion Summary]

Data Dictionary Tables:

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                             0                0                0                0
CHAR                                 0                0                0                0
LONG                                 0                0                0                0
CLOB                                 0                0                0                0
VARRAY                               0                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                                0                0                0                0
Total in percentage              0.000%           0.000%           0.000%           0.000%

XML CSX Dictionary Tables:

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                             0                0                0                0
CHAR                                 0                0                0                0
LONG                                 0                0                0                0
CLOB                                 0                0                0                0
VARRAY                               0                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                                0                0                0                0
Total in percentage              0.000%           0.000%           0.000%           0.000%

[Application Data Conversion Summary]

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                    43,502,802               51                0                0
CHAR                               747                0              499                0
LONG                                 0                0                0                0
CLOB                                 0                0                0                0
VARRAY                               0                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                       43,503,549               51              499                0
Total in percentage             99.999%           0.000%           0.001%           0.000%

[Distribution of Convertible, Truncated and Lossy Data by Table]

Data Dictionary Tables:

USER.TABLE                                              Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------

XML CSX Dictionary Tables:

USER.TABLE                                              Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------

Application Data:

USER.TABLE                                              Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A                                                            1                0                0
YANG.FIXED                                                        0              499                0
YANG.TCHAR                                                       49                0                0
YANG.TEST_CHAR                                                    1                0                0
-------------------------------------------------- ---------------- ---------------- ----------------

[Distribution of Convertible, Truncated and Lossy Data by Column]

Data Dictionary Tables:

USER.TABLE|COLUMN                                       Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------

XML CSX Dictionary Tables:

USER.TABLE|COLUMN                                       Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------

Application Data:

USER.TABLE|COLUMN                                       Convertible       Truncation            Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A|VAL                                                        1                0                0
YANG.FIXED|VAL2                                                   0              499                0
YANG.TCHAR|VAL                                                   49                0                0
YANG.TEST_CHAR|V                                                  1                0                0
-------------------------------------------------- ---------------- ---------------- ----------------

[Indexes to be Rebuilt]

USER.INDEX on USER.TABLE(COLUMN)                                                         
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------

[Truncation due to codepoint semantic]

USER.TABLE|COLUMN                                        Truncation
-------------------------------------------------- ----------------
YANG.TEST_CHAR|V                                                  1
-------------------------------------------------- ----------------

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-689376/,如需轉載,請註明出處,否則將追究法律責任。

相關文章