Csscan&Lcsscan

yyp2009發表於2012-04-10

CSS

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

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

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

連線到:

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

連線到:

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

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

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

<!-- Gen

AAAMkMAAFAAAAVfAAB lossy conversion

<!-- Gen

AAAMkMAAFAAAAVfAAC lossy conversion

<!-- Gen

AAAMkMAAFAAAAVfAAD lossy conversion

<!-- Gen

AAAMkMAAFAAAAVfAAE lossy conversion

<!-- Gen

AAAMkMAAFAAAAVfAAF lossy conversion

<!-- Gen

AAAMkMAAFAAAAVfAAG lossy conversion

<!-- 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/，如需轉載，請註明出處，否則將追究法律責任。