Csscan Output Explained [ID 444701.1]
Modified: Nov 20, 2012 Type: REFERENCE Status: PUBLISHED Priority: 3
In this Document
Purpose
Scope
Details
A) Csscan output files.
A.1) The .out file
A.2) The .txt file
A.3) The .err file.
B) The meaning of the status of data in the Conversion Summary of the .txt file:
B.1) CHANGELESS data.
B.2) CONVERTIBLE data.
B.3) TRUNCATION data.
B.4) LOSSY data.
C) What to do if you have LOSSY data?
C.1) The lossy characters are not known in the target/new characterset (less likely to happen)
C.2) The source database has data (codes) that are NOT defined in the source characterset.
C.3) The limit of what Csscan can detect when dealing with lossy, an example:
D) What output do you need to see in Csscan to do a characterset change?
D.1) (any Oracle version) To use a (full) exp/imp into a database with the new characterset.
D.2) (8i/9i only) To use "Alter Database Character Set".
D.3) (10g and 11g) To use Csalter.
E) Do I need to always run a full database scan? / The Csscan EXCLUDE , USER or TABLE parameters do not appear to work.
F) Do I need to specify toNchar and/or fromNchar when changing the NLS_CHARACTERSET? Can I specify TOCHAR=AL16UTF16?
G) Can I specify case sensitive user/table/column names as arguments for Csscan?
H) how to find the csscan processes in the database and have an idea what they are doing?
I) Is it possible to use Csscan results for own selects instead of using the flat text files?
J) the number of rows in csscan output looks wrong
References
Applies to:
Oracle Server - Enterprise Edition - Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
Oracle Server - Standard Edition - Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Purpose
To install Csscan please see:
Note 458122.1 Installing and Configuring Csscan in 8i and 9i (Database Character Set Scanner)
Note 745809.1 Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner)
For 8i and 9i please do install Csscan version 1.2 , do not use the old csscan versions included in 8i/9i .
The Csscan tool analyzes the code points in the database and verifies that they are known in the source the database characterset and
known in the target database characterset.
The output of the Csscan utility is vital to determining the health of the data in the database, and this becomes especially crucial when
changing charactersets, as well as during import and export operations or database link transfers when source and target database
differ in characterset.
Knowing what the Csscan output shows, and what it means and it's limits helps you to ensure the integrity of the data.
Please note that this note documents csscan output.
Csscan is used in the step by step guides on changing the NLS_CHARACTERSET like
note 260192.1 Changing the
NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) , a list of other guides can be found in note 225912.1 Changing the Database
Document Display https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx...
1／16 2013/1/15 下午 10:18
剩余15页未读，继续阅读
资源评论
壁虎9192020-01-13最垃圾的文档还好意思收这么贵的积分
