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
-------------------------------------------------- ----------------