CSSCAN使用说明

我们经常需要将数据从一个数据库导入到另一个数据库.经常会碰到因两个数据库不同字符集而导致数据导入出现数据不全的情况.

ORACLE官方提供了CSSCAN这个工具,可以在导入前对数据进行分析....

 

csscan (Character Set Scanner)
All Oracle Applications customers must refer to MetaLink <Note:124721.1> : 'Migrating an
Applications Installation to a New Character Set.' This document describes and explains
the supported path to upgrade/migrate an existing Applications installation to UTF8.

1. 下载不同操作系统下的CSSCAN
下载地址：http://www.oracle.com/technology/software/tech/globalization/index.html
2. 使用方法(HPUX11I+ORACLE8174为例)
a> 在HPUX11I+ORACLE8174的CSSCAN为: csscan_12_hpux_920.tar.Z
b> 以bin方式FTP到$ORACLE_HOME下
c> gunzip csscan_12_hpux_920.tar.Z
得到:csscan_12_hpux_817.tar
d> tar -xvf csscan_12_hpux_817.tar
x csscan, 974848 bytes, 1904 tape blocks
x analyze_histgrm.sql, 1684 bytes, 4 tape blocks
x analyze_rule.sql, 1639 bytes, 4 tape blocks
x analyze_source.sql, 1668 bytes, 4 tape blocks
x csminst.sql, 16878 bytes, 33 tape blocks
x readme_csscan1.2, 2169 bytes, 5 tape blocks
e> 以sys用户运行csminst.sql
f> 将csscan拷贝到$ORACLE_HOME/bin目录下
g> semdg1:orahr 10> pwd
/oracle/HR
semdg1:orahr 11> cd bin
semdg1:orahr 12> csscan

Character Set Scanner v1.2 : Release 8.1.7 .4.0 - Production on Mon Nov 7 09:00:24 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Username: sahris

Password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7 .4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
(1)Full database, (2)User, (3)Table: 1 > 2 (3 种可分析模式 )
Current database character set is ZHS16CGB231280.
Enter new database character set name: > utf8
Enter array fetch buffer size: 10240 >
Enter number of scan processes to utilize(1..32): 1 > 3
Enter table name to scan: > h2007tt
Enter table name to scan: >
Enumerating table to scan...
table(s) contain no character type columns
Scanner terminated successfully.
h> 在 $ORACLE_HOME/bin 目录下回生成 scan.txt, 部分内容如下 :
SAHRIS.SAHRIS_GMAS01TT|DEPTNM102,779 0 0
SAHRIS.SAHRIS_GMAS01TT|EMAIL 28 0 0
SAHRIS.SAHRIS_GMAS01TT|ENGNAME 19 0 0
................................................
以上内容表示 , 表 SAHRIS_GMAS01TT 的 DEPTNM, EMAIL, ENGNAME 三个字段从 ZHS16CGB231280 字符集 IMPORT 到
UFT8 的字符集的数据库中可能会出现错误 . 应该重新定义这三个字段的长度 .