 |
|
Oracle Tips by Burleson |
Oracle 10g Enhanced Character Set Scanner and Converter
The Character Set Scanner has been enhanced to
support the scanning of nested tables and character semantics
objects. The database scan summary report now provides additional
information on the source database, along with statistics on
possible size expansion. However, the character scanner still
doesn't support the scanning of VARRAY type objects.
Character Set Scanner Reports
For those of you who have used the character
scanner in its previous versions, the biggest change you will see
(other than it doesn't complain about nested tables) is in the
report format. Almost every section of the scanner report has been
changed.
Let's look at the results of a character scan
for converting the default Oracle Database 10g characterset (WE....)
to simplified Chinese 16 bit (ZHS16CGB231280). Install the character
set scanner (run csminst.sql in $ORACLE_HOME/rdbms/admin, we suggest
editing it first to change the default tablespace of the csmig user
to USERS or at least something other than the default value of
SYSTEM).
The parameter file I used was:
USERID=system/not_my_password
FULL=y
TOCHAR=ZHS16CGB231280
ARRAY=40960
FEEDBACK=1000
The command to run the character scanner after
it is installed is "csscan user/password parfile=file_name", as an
alternative, you can also use command line arguments instead of a
parameter file.
The resulting report (located in scan.txt in
the directory from which csscan is run is shown below (the funny
thing is, even when I specified the same characterset as in the test
database, it still complained about the same entry...must be
something bad about that one entry! Of course this was on a beta 1
release!):
Database Scan
Summary Report
Time Started
: 2003-09-14 13:04:25
Time Completed: 2003-09-14 13:11:20
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
