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


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



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

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

VARCHAR2                    26,854,997                0              136

CHAR                         8,603,927                0                3

LONG                               631                0                0

CLOB                                 0                0                0

VARRAY                               0                0                0

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

Total                       35,459,555                0              139

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