oracle字符集深入研究(五)

2014-11-24 11:49:01 · 作者: · 浏览: 3
Individual Exception Report... Scanner terminated successfully. [oracle@tf lbuilder]$


完成之后会产生三个日志文件:

[oracle@tf lbuilder]$ ls -l
total 72
drwxr-x--- 2 oracle oinstall 4096 Oct 10 22:43 jlib
-rwxr-xr-x 1 oracle oinstall 891 Oct 10 22:43 lbuilder
-rw-r--r-- 1 oracle oinstall 24576 Dec 4 07:17 us.dmp
-rw-r--r-- 1 oracle oinstall 1357 Dec 4 07:49 verify.log.err
-rw-r--r-- 1 oracle oinstall 489 Dec 4 07:49 verify.log.out
-rw-r--r-- 1 oracle oinstall 5661 Dec 4 07:49 verify.log.txt
[oracle@tf lbuilder]$

查看相关err内容:

[oracle@tf lbuilder]$ cat verify.log.err
Database Scan Individual Exception Report


[Database Scan Parameters]

Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name tf1
Database Version 10.2.0.1.0
Scan type Selective tables
Scan CHAR data YES
Database character set WE8ISO8859P1
FROMCHAR WE8ISO8859P1
TOCHAR US7ASCII
Scan NCHAR data NO
Array fetch buffer size 1024000
Number of processes 10
Capture convertible data NO
------------------------------ ------------------------------------------------

[Data Dictionary individual exceptions]


[Application data individual exceptions]

[oracle@tf lbuilder]$

发现没有存在数据出现乱码的对象信息,说明导入和导出是在这两个不同字符集平台上数据在进行字符转换的时候是没有问题的。

另外txt文件是scan的过程信息,out是打在页面上的显示信息;

[oracle@tf lbuilder]$ cat verify.log.txt 
Database Scan Summary Report

Time Started  : 2013-12-04 07:48:57
Time Completed: 2013-12-04 07:49:17

Process ID         Time Started       Time Completed
---------- -------------------- --------------------
         1  2013-12-04 07:49:16  2013-12-04 07:49:16
---------- -------------------- --------------------

[Database Size]

Tablespace                           Used            Free           Total       Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM                            473.81M           6.19M         480.00M            .00K
UNDOTBS1                            2.94M          22.06M          25.00M            .00K
SYSAUX                            232.69M           7.31M         240.00M            .00K
TEMP                                 .00K            .00K            .00K            .00K
USERS                             448.00K           4.56M           5.00M            .00K
TEST                               64.00K          19.94M          20.00M            .00K
TEMP02                               .00K            .00K            .00K            .00K
RHYS                                6.06M           3.94M          10.00M            .00K
------------------------- --------------- --------------- --------------- ---------------
Total                             716.00M          64.00M         780.00M            .00K

[Database Scan Parameters]

Parameter                      Value                                           
------------------------------ ------------------------------------------------
CSSCAN Version                 v2.1                                            
Instance Name                  tf1                                             
Database Version               10.2.0.1.0                                      
Scan type                      Selective tables                                
Scan CHAR data                 YES                                             
Database character set         WE8ISO8859P1                                    
FROMCHAR                       WE8ISO8859P1                                    
TOCHAR                         US7ASCII                                        
Scan NCHAR data                NO                                              
Array fetch buffer size        1024000                                         
Number of processes            10                                              
Capture convertible data       NO                                              
------------------------------ ------------------------------------------------

[Scan Summary]

All character type application data remain the same in the new character set

[Data Dictionary Conversion Summary]

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