Character set change impact analysis

Before changing the existing character set to a new character set, we can analyze the impact of the change (in advance) by using the csscan utility.

$ csscan system/manager FULL=Y TOCHAR=WE8ISO8859P1 ARRAY=1024000 PROCESS=10

Character Set Scanner v2.1 : Release – Production on Wed Feb 6 19:30:44 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release – 64bit Production
With the Partitioning and Data Mining options

Enter array fetch buffer size: 1024000 >

Enter number of scan processes to utilize(1..32): 1 > 3

Enumerating tables to scan…

Check following files after scan

-rw-r–r– 1 oracle dba scan.err – errors with rowid’s
-rw-r–r– 1 oracle dba scan.out – scan output
-rw-r–r– 1 oracle dba scan.txt – scan summary


Change O7_DICTIONARY_ACCESSIBILITY parameter in init.ora, if this utility is not executed by SYS.

Before executing csscan utility, create character set migration utility schema, using csminst.sql. Otherwise csscan will throw CSS-00107: Character set migration utility schema not installed

This entry was posted in Oracle Language Support and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s