完成之后会产生三个日志文件:
[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