oracle的字符集檢查工具CSSCAN(二)
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
-------------------------------------------------- ----------------
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle的字符集檢查工具CSSCAN(一)OracleCSS
- oracle的字符集檢查工具CSSCAN(三)OracleCSS
- 在oracle 10.2.0.4上使用字符集掃描工具Csscan（二）OracleCSS
- 【csscan】字符集掃描工具csscan“實操式”品味CSS
- Oracle工具——csscanOracleCSS
- Oracle CSSCAN工具使用OracleCSS
- 在oracle 10.2.0.4上配置字符集掃描工具Csscan（一）OracleCSS
- oracle10g_csscan_更變資料庫字符集及國家字符集的工具測試OracleCSS資料庫
- Oracle字符集的檢視查詢和Oracle字符集的設定修改Oracle
- 【TUNE_ORACLE】Oracle檢查點（二）檢查點效能Oracle
- CSSCAN使用說明[字符集問題]CSS
- CSSCAN掃描字符集轉換耗損CSS
- oracle資料庫巡檢（二）全面檢查Oracle資料庫
- 檢視、修改oracle字符集，檢視oracle版本Oracle
- Oracle字符集的檢視和修改Oracle
- Oracle 字符集的檢視和修改Oracle
- 摘--檢視oracle 字符集Oracle
- （轉）Oracle 字符集的檢視和修改Oracle
- Oracle 字符集的檢視和修改（轉）Oracle
- oracle 字符集檢視與修改Oracle
- 檢視和修改Oracle字符集Oracle
- oracle字符集轉換分析工具Oracle
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（三）專案檢查步驟概述其二Oracle
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（二）專案檢查步驟概述其一Oracle
- 檢視oracle資料庫字符集Oracle資料庫
- OTools--csscan工具幫助記錄。CSS
- oracle資料庫字符集characterset遷移及變更之csscan及csalter.plb系列三Oracle資料庫CSS
- oracle資料庫字符集characterset遷移及變更之csscan及csalter.plb系列四Oracle資料庫CSS
- Oracle查詢轉換（二）複雜檢視合併Oracle
- rac中的cluvfy檢查工具使用
- Oracle 檢查點涉及的SCNOracle
- 怎樣修改檢視Oracle字符集及怎樣修改字符集 ztOracle
- ORACLE學習之九 Oracle 字符集的檢視和修改 （轉帖）Oracle
- Oracle 檢查點佇列與增量檢查點Oracle佇列
- oracle checkpoint檢查點Oracle
- 檢查 oracle 壞塊Oracle
- Oracle基本資訊檢查Oracle
- oracle資料庫sql查詢檢視第二次查詢很慢Oracle資料庫SQL