1 Reply Latest reply: Sep 4, 2013 3:35 AM by DK2010 RSS

    CSSCAN showing lossy DATA while source and target with same charecterset

    dba.arnab

      Hello,

       

      We are going to migrate oracle 10.2.0.4.0 (Oracle Linux Server release 5.6) to new server with 11g on it.

      Current charecterset details :

      NLS_CHARACTERSET : AL32UTF8

      NLS_NCHAR_CHARACTERSET : AL16UTF16

       

      Target database charecterset will also be AL32UTF8. I have ran csscan utility with full=y and tochar=AL32UTF8 to ensure any change.

      As per the csscan output, it is showing huge list of lossy data. Pasted few of lines for reference.

      Please suggest what we need to do. I am confused if we need to run anything to make changes in existing setup or we can go directly to expdp/impdp in new server.

       

       

      Part of output:

       

      [Database Scan Parameters]

       

       

      Parameter                      Value

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

      CSSCAN Version                 v2.1

      Instance Name                  ######

      Database Version               10.2.0.4.0

      Scan type                      Full database

      Scan CHAR data?                YES

      Database character set         AL32UTF8

      FROMCHAR                       AL32UTF8

      TOCHAR                         AL32UTF8

      Scan NCHAR data?               NO

      Array fetch buffer size        1024000

      Number of processes            4

      Capture convertible data?      NO

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

      [Data Dictionary individual exceptions]

       

       

      User  : SYS

      Table : SOURCE$

      Column: SOURCE

      Type  : VARCHAR2(4000)

      Number of Exceptions         : 20

      Max Post Conversion Data Size: 4000

       

       

      ROWID              Exception Type      Size Cell Data(first 30 bytes)

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

      AAAABIAABAAAOaUAB8 lossy conversion              *     (3) Strip any non-n

      AAAABIAABAAAOhNAA1 lossy conversion                  Affects the value of

      AAAABIAABAAAPX5AB5 lossy conversion              *     (3) Strip any non-n

      AAAABIAABAAAQ+kACu lossy conversion              *     (3) Strip any non-n

      AAAABIAABAAAQ+lAAo lossy conversion

      AAAABIAABAAARagAAh lossy conversion              *     (3) Strip any non-n

      AAAABIAABAAAUX1AAU lossy conversion             a_array(13) := '£';

       

      ............

      .......

       

      User  : FOOT_TEST

      Table : MI_ACTIVITIES_DATA

      Column: ACTIVITY_DESCRIPTION

      Type  : VARCHAR2(4000)

      Number of Exceptions         : 17

      Max Post Conversion Data Size: 1645

       

       

      ROWID              Exception Type      Size Cell Data(first 30 bytes)

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

      AAJeJGAAAAAABVTAAD lossy conversion          Deutsche Telekom is planning

      AAJeJGAAAAAABVXAAC lossy conversion          Kelly services, completes the

      AAJeJGAAAAAABVaAAL lossy conversion          Qatar Telecom QSC signed an a

      AAJeJGAAAAAABViAAG lossy conversion          Aon Plc announced the commenc

      AAJeJGAAAAAABVlAAU lossy conversion          �United Airlines announced

      AAJeJGAAAAAABVqAAR lossy conversion          Deutsche Telekom is planning

      AAJeJGAAAAAABm4AAL lossy conversion          ADP TotalSource� is expandi

      AAJeJGAAAAAABm7AAM lossy conversion         The IBM board of directors dec

      AAJeJGAAAAAABmVAAR lossy conversion          The Supervisory Board of Deut

      AAJeJGAAAAAABmWAAD lossy conversion          Deutsche Telekom is planning

      AAJeJGAAAAAABmXAAB lossy conversion          Kelly services, completes the

      ............

      ............

       

       

      Regards

       

      Sinha.