RE: CSALTER.plb Failing ...... Attempting to Alter Character Set from US7ASCII to AL32UTF8

Folks



On an internal Test 10gR2 Database running of CSALTER.plb is Failing
when Attempting to Alter Character Set from US7ASCII to AL32UTF8.



Qs Does User/Application Data which during CSSCAN reported 2 types of
Errors i.e. "Truncation" & "Lossy conversion" necessarily needs to be
Manually Corrected?



NOTE - We do NOT seek to Manually correct the Application Data, but want
CSALTER to go thru successfully.



Qs Should the 3 indexes which need to be RE-built be DROPPED before
Running the CSALTER.PLB Script & RE-built After ALTERATION?



Application = Banking Product

O.S. = HP-UX B.11.11



Thanks indeed



Vivek



OUTPUT of CSALTER.PLB:-



SQL> start ?/rdbms/admin/csalter.plb



Checking data validility...

Exceptional data found in scanner result

Checking or Converting phrase did not finish successfully



SUMMARY Report of CSSCAN of the FULL Database is as follows:-



[Data Dictionary Conversion Summary]

.. .

The data dictionary can be safely migrated using the CSALTER script



[Application Data Conversion Summary]



Datatype                    Changeless      Convertible       Truncation
Lossy

--------------------- ---------------- ---------------- ----------------
----------------

VARCHAR2                    26,854,997                0              136
165

CHAR                         8,603,927                0                3
3

LONG                               631                0                0
13,229

CLOB                                 0                0                0
0

VARRAY                               0                0                0
0

--------------------- ---------------- ---------------- ----------------
----------------

Total                       35,459,555                0              139
13,397

Total in percentage             99.962%           0.000%
0.000%           0.038%



[Indexes to be Rebuilt]



Showed 3 Indexes to be RE-Built



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts:

  • » RE: CSALTER.plb Failing ...... Attempting to Alter Character Set from US7ASCII to AL32UTF8