What is Character Set Scanner:
The Character Set Scanner provides an assessment of the feasibility and potential issues in migrating an Oracle database to a new database character set.
The Character Set Scanner checks all character data in the database and tests for the effects and problems of changing the character set encoding.
At the end of the scan, it generates a summary report of the database scan.
This report shows the scope work required to convert the database to a new character set.
[Source: http://download.oracle.com/docs/cd/B10501_01/server.920/a96529/ch11.htm]
Lab Exercise Steps:
Step 1:
You can download the utitily from the following URL:
http://www.oracle.com/technetwork/topics/index-085942.html
Step 2:
Next, extract the zip file, connect to the database as sys and run the csminst.sql
to create the user CSMIG and its database objects.
Step 3:
To scan the database character set, run the csscan.exe utility
Step 4:
Normally, two files will be generated, namely, scan.txt and scan.out
if errors were found during the scan, scan.err file will also be created.
Read through the files to correct the errors if possible so that database migration can be successful.
留言列表
{{ article.title }}