1 C:\Documents and Settings\pengju> csscan -help
Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on 星期二 4月 10 21:03:48 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Scanner prompt you for parameters by entering the CSSCAN
command followed by your username/password:
Example: CSSCAN SYSTEM/MANAGER
Or, you can control how Scanner runs by entering the CSSCAN command
followed by various parameters. To specify parameters, you use keywords:
Example: CSSCAN SYSTEM/MANAGER FULL=y TOCHAR=utf8 ARRAY=1024000 PROCESS=3
Keyword Default Prompt Description
---------- ------- ------ -------------------------------------------------
USERID yes username/password
FULL N yes scan entire database
USER yes owner of tables to be scanned
TABLE yes list of tables to scan
COLUMN yes list of columns to scan
EXCLUDE list of tables to exclude from scan
TOCHAR yes new database character set name
FROMCHAR current database character set name
TONCHAR new national character set name
FROMNCHAR current national character set name
ARRAY 1024000 yes size of array fetch buffer
PROCESS 1 yes number of concurrent scan process
MAXBLOCKS split table if block size exceed MAXBLOCKS
CAPTURE N capture convertible data
SUPPRESS maximum number of exceptions logged for each table
FEEDBACK report progress every N rows
BOUNDARIES list of column size boundaries for summary report
LASTRPT N generate report of the last database scan
LOG scan base file name of report files
PARFILE parameter file name
PRESERVE N preserve existing scan results
LCSD N no enable language and character set detection
LCSDDATA LOSSY no define the scope of the detection
HELP N show help screen (this screen)
QUERY N select clause to scan subset of tables or columns
---------- ------- ------ -------------------------------------------------
Scanner terminated successfully.
C:\Documents and Settings\pengju>lcsscan -help
Language and Character Set File Scanner v2.1
(c) Copyright 2003, 2004 Oracle Corporation. All rights reserved.
You can control how LCSSCAN runs by entering the LCSSCAN command
followed by the required parameters. To specify parameters, you use
keywords:
Example: LCSSCAN RESULTS=2 END=1000 FORMAT=HTML FILE=index.html
Keyword Description (Default)
--------------------------------------------------------------------
RESULTS number of language and character set pairs to return (1)
BEGIN beginning byte offset of file (1)
END ending byte offset of file (end of file)
FORMAT file format TEXT, HTML or AUTO detect (TEXT)
FILE name of input file
HELP show help screen (this screen)
2 C:\Documents and Settings\pengju>sqlplus system/kk
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 4月 10 20:59:01 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @@?/rdbms/admin/csminst.sql
grant READ on directory log_file_dir to system
*
第 1 行出现错误:
ORA-01749: 用户不能自己为自己 GRANT/REVOKE 权限
grant READ on directory data_file_dir to system
*
第 1 行出现错误:
ORA-01749: 用户不能自己为自己 GRANT/REVOKE 权限
drop user csmig cascade
*
第 1 行出现错误:
ORA-01918: 用户 'CSMIG' 不存在
Please create password for user CSMIG:
输入 csmig_passwd 的值: kk
原值 1: create user csmig identified by &csmig_passwd
新值 1: create user csmig identified by kk
用户已创建。
授权成功。
授权成功。
……
同义词已创建。
视图已创建。
视图已创建。
提交完成。
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
3 C:\Documents and Settings\pengju>sqlplus system/kk
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 4月 10 20:59:25 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\pengju>csscan system/kk full=y tochar=utf8;
Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on 星期二 4月 10 20:59:50 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
CSS-00115: invalid character set name utf8;
Scanner terminated unsuccessfully.
C:\Documents and Settings\pengju>csscan system/kk
Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on 星期二 4月 10 20:59:54 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
(1)Full database, (2)User, (3)Table, (4)Column: 1 > 1
Current database character set is ZHS16GBK.
Enter new database character set name: > WE8ISO8859P1
Enter array fetch buffer size: 1024000 >
Enter number of scan processes to utilize(1..32): 1 >
Enumerating tables to scan...
. process 1 scanning SYS.SOURCE$[AAAABIAABAAAAIRAAA]
. process 1 scanning SYS.ATTRIBUTE$[AAAAC1AABAAAAURAAA]
.……
. process 1 scanning SYSTEM.LOGMNRC_GTLO[AAABa0AADAAAAZhAAA]
. process 1 scanning SYS.WRH$_LATCH_MISSES_SUMMARY[AAAMfzAADAAABOJAAA]
Creating Database Scan Summary Report...
Creating Individual Exception Report...
Scanner terminated successfully.
C:\Documents and Settings\pengju>
4 scan.err:
Database Scan Individual Exception Report
[Database Scan Parameters]
Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name orcl
Database Version 10.2.0.1.0
Scan type Full database
Scan CHAR data? YES
Database character set ZHS16GBK
FROMCHAR ZHS16GBK
TOCHAR WE8ISO8859P1
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 1
Capture convertible data? NO
------------------------------ ------------------------------------------------
[Data Dictionary individual exceptions]
User : SYS
Table : JOB$
Column: NLSENV
Type : VARCHAR2(4000)
Number of Exceptions : 1
Max Post Conversion Data Size: 210
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAADtAABAAAAZ6AAA lossy conversion NLS_LANGUAGE='SIMPLIFIED CHINE
------------------ ------------------ ----- ------------------------------
User : CTXSYS
Table : DR$INDEX_VALUE
Column: IXV_VALUE
Type : VARCHAR2(500)
Number of Exceptions : 76
Max Post Conversion Data Size: 27
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAJ+uAADAAABu3AB+ lossy conversion 处在
AAAJ+uAADAAABu3AB/ lossy conversion 此项
AAAJ+uAADAAABu3AB4 lossy conversion 必将
AAAJ+uAADAAABu3AB5 lossy conversion 必须
AAAJ+uAADAAABu3AB6 lossy conversion 并非
AAAJ+uAADAAABu3AB7 lossy conversion 超过
AAAJ+uAADAAABu3AB8 lossy conversion 成为
AAAJ+uAADAAABu3AB9 lossy conversion 除了
AAAJ+uAADAAABu3AC+ lossy conversion 以上
AAAJ+uAADAAABu3AC/ lossy conversion 因此
AAAJ+uAADAAABu3AC0 lossy conversion 现在
AAAJ+uAADAAABu3AC1 lossy conversion 相当
AAAJ+uAADAAABu3AC2 lossy conversion 新的
AAAJ+uAADAAABu3AC3 lossy conversion 许多
AAAJ+uAADAAABu3AC4 lossy conversion 也是
AAAJ+uAADAAABu3AC5 lossy conversion 一得
AAAJ+uAADAAABu3AC6 lossy conversion 一同
AAAJ+uAADAAABu3AC7 lossy conversion 一再
AAAJ+uAADAAABu3AC8 lossy conversion 已经
AAAJ+uAADAAABu3AC9 lossy conversion 以及
AAAJ+uAADAAABu3ACA lossy conversion 从而
AAAJ+uAADAAABu3ACB lossy conversion 存在着
AAAJ+uAADAAABu3ACC lossy conversion 达到
AAAJ+uAADAAABu3ACD lossy conversion 大量
AAAJ+uAADAAABu3ACE lossy conversion 带来
AAAJ+uAADAAABu3ACF lossy conversion 带着
AAAJ+uAADAAABu3ACG lossy conversion 但是
AAAJ+uAADAAABu3ACH lossy conversion 当时
AAAJ+uAADAAABu3ACI lossy conversion 得到
AAAJ+uAADAAABu3ACJ lossy conversion 都是
AAAJ+uAADAAABu3ACK lossy conversion 对于
AAAJ+uAADAAABu3ACL lossy conversion 而且
AAAJ+uAADAAABu3ACM lossy conversion 而言
AAAJ+uAADAAABu3ACN lossy conversion 方面
AAAJ+uAADAAABu3ACO lossy conversion 各方面
AAAJ+uAADAAABu3ACP lossy conversion 各种
AAAJ+uAADAAABu3ACQ lossy conversion 共同
AAAJ+uAADAAABu3ACR lossy conversion 很少
AAAJ+uAADAAABu3ACS lossy conversion 很有
AAAJ+uAADAAABu3ACT lossy conversion 还将
AAAJ+uAADAAABu3ACU lossy conversion 还是
AAAJ+uAADAAABu3ACV lossy conversion 还有
AAAJ+uAADAAABu3ACW lossy conversion 回到
AAAJ+uAADAAABu3ACX lossy conversion 获得了
AAAJ+uAADAAABu3ACY lossy conversion 或者
AAAJ+uAADAAABu3ACZ lossy conversion 基本上
AAAJ+uAADAAABu3ACa lossy conversion 基于
AAAJ+uAADAAABu3ACb lossy conversion 即可
AAAJ+uAADAAABu3ACc lossy conversion 较大
AAAJ+uAADAAABu3ACd lossy conversion 尽管
AAAJ+uAADAAABu3ACe lossy conversion 就是
AAAJ+uAADAAABu3ACf lossy conversion 具有
AAAJ+uAADAAABu3ACg lossy conversion 可能
AAAJ+uAADAAABu3ACh lossy conversion 可以
AAAJ+uAADAAABu3ACi lossy conversion 来自
AAAJ+uAADAAABu3ACj lossy conversion 两个
AAAJ+uAADAAABu3ACk lossy conversion 没有
AAAJ+uAADAAABu3ACl lossy conversion 目前
AAAJ+uAADAAABu3ACm lossy conversion 哪里
AAAJ+uAADAAABu3ACn lossy conversion 那里
AAAJ+uAADAAABu3ACo lossy conversion 却是
AAAJ+uAADAAABu3ACp lossy conversion 如果
AAAJ+uAADAAABu3ACq lossy conversion 如何
AAAJ+uAADAAABu3ACr lossy conversion 什么
AAAJ+uAADAAABu3ACs lossy conversion 实在
AAAJ+uAADAAABu3ACt lossy conversion 所需
AAAJ+uAADAAABu3ACu lossy conversion 所有
AAAJ+uAADAAABu3ACv lossy conversion 他们
AAAJ+uAADAAABu3ACw lossy conversion 它的
AAAJ+uAADAAABu3ACx lossy conversion 为了
AAAJ+uAADAAABu3ACy lossy conversion 我们
AAAJ+uAADAAABu3ACz lossy conversion 下去
AAAJ+uAADAAABu3ADA lossy conversion 因为
AAAJ+uAADAAABu3ADB lossy conversion 由于
AAAJ+uAADAAABu3ADC lossy conversion 这个
AAAJ+uAADAAABu3ADD lossy conversion 之一
------------------ ------------------ ----- ------------------------------
[Application data individual exceptions]
User : PM
Table : ONLINE_MEDIA
Column: SYS_NC00042$
Type : CLOB
Number of Exceptions : 7
Max Post Conversion Data Size: 52460
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMkMAAFAAAAVfAAA lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAB lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAC lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAD lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAE lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAF lossy conversion <?xml version="1.0"?>
<!-- Gen
AAAMkMAAFAAAAVfAAG lossy conversion <?xml version="1.0"?>
<!-- Gen
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_OMS_PARAMETERS
Column: VALUE
Type : VARCHAR2(256)
Number of Exceptions : 1
Max Post Conversion Data Size: 41
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMMeAADAAAFx3AAA lossy conversion 13-3月 -2012 00:00:36
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_STRING_METRIC_HISTORY
Column: STRING_VALUE
Type : VARCHAR2(4000)
Number of Exceptions : 234
Max Post Conversion Data Size: 57
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMLTAADAAAFpEAA+ lossy conversion 3月 18, 2012 09:15:51 下午
AAAMLTAADAAAFpEAA/ lossy conversion 3月 18, 2012 09:26:41 下午
……
AAAMLTAADAAAFpIABF lossy conversion 3月 28, 2012 11:33:14 下午
AAAMLTAADAAAFpIABG lossy conversion 3月 28, 2012 11:44:04 下午
AAAMLTAADAAAFpIABH lossy conversion 3月 28, 2012 11:54:54 下午
AAAMLTAADAAAFpIABI lossy conversion 3月 29, 2012 12:05:45 上午
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_HC_VENDOR_SW_SUMMARY
Column: NAME
Type : VARCHAR2(128)
Number of Exceptions : 10
Max Post Conversion Data Size: 69
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMOvAADAAAGDIAAA lossy conversion 360?1?? 1.9.0.1111 ?yê?
AAAMOvAADAAAGDIAAB lossy conversion 360°2è??àê?
AAAMOvAADAAAGDIAAD lossy conversion ?Déìò?DDò?í?í¨í?
AAAMOvAADAAAGDIAAF lossy conversion 1è?è?′ò?ê?è?·¨ 2.
AAAMOvAADAAAGDIAAH lossy conversion ?á?òò?à?oD 2011
AAAMOvAADAAAGDIAAI lossy conversion Microsoft .NET Framework 3.5 S
AAAMOvAADAAAGDIAAS lossy conversion ±?·?ó°ò?5
AAAMOvAADAAAGDIAAU lossy conversion WinRAR ?1?????t1üàí?
AAAMOvAADAAAGDIAAX lossy conversion ìú??QQ2010
AAAMOvAADAAAGDIAAa lossy conversion 360°2è??ˉàà?÷ 4.0 ?y
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_HC_OS_COMPONENTS
Column: DESCRIPTION
Type : VARCHAR2(2000)
Number of Exceptions : 104
Max Post Conversion Data Size: 46
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMOtAADAAAGC0AAA lossy conversion Windows XP °2è??üD? (KB9
AAAMOtAADAAAGC0AAC lossy conversion Windows XP °2è??üD? (KB9
AAAMOtAADAAAGC0AAD lossy conversion Windows XP °2è??üD? (KB9
……
AAAMOtAADAAAGC4ABf lossy conversion Windows XP °2è??üD? (KB9
AAAMOtAADAAAGC4ABg lossy conversion Windows XP °2è??üD? (KB9
AAAMOtAADAAAGC4ABh lossy conversion Windows XP °2è??üD? (KB9
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_HC_FS_MOUNT_DETAILS
Column: RESOURCE_NAME
Type : VARCHAR2(128)
Number of Exceptions : 2
Max Post Conversion Data Size: 15
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMOuAADAAAGDAAAE lossy conversion ò??ˉ?í
AAAMOuAADAAAGDAAAF lossy conversion ò??ˉ?í
------------------ ------------------ ----- ------------------------------
User : SYSMAN
Table : MGMT_HC_VENDOR_SW_SUMMARY
Column: VENDOR_NAME
Type : VARCHAR2(128)
Number of Exceptions : 4
Max Post Conversion Data Size: 27
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAMOvAADAAAGDIAAB lossy conversion 360°2è??DD?
AAAMOvAADAAAGDIAAH lossy conversion ?á?ò????
AAAMOvAADAAAGDIAAS lossy conversion ±±??±?·?í??ê???
AAAMOvAADAAAGDIAAX lossy conversion ìú??????(é??ú)óD
------------------ ------------------ ----- ------------------------------
5 Local Builder:
picture elliptical。
6 See also:
E:\oracle\product\10.2.0\db_2\nls\csscan\sql
analyze_histgrm.sql
analyze_rule.sql
analyze_source.sql
----------end-------------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-720863/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13750068/viewspace-720863/