2 Replies Latest reply: Sep 17, 2012 10:42 AM by Amar_Singh RSS

    CSSCAN RESULT

    517214
      Hi Guys,
      I have just finished running a csscan for a schema.
      The results are listed below from scan.err file.
      What exactly do i need to do to fix these set of column size exceeded and lossy errors please?
      Parameter                      Value
      ------------------------------ ------------------------------------------------
      CSSCAN Version                 v2.1
      Instance Name                  FCHDT
      Database Version               10.2.0.5.0
      Scan type                      User tables
      User name                      FCHDBA
      Scan CHAR data?                YES
      Database character set         WE8DEC
      FROMCHAR                       WE8DEC
      TOCHAR                         AL32UTF8
      Scan NCHAR data?               NO
      Array fetch buffer size        1024000
      Number of processes            1
      Capture convertible data?      NO
      ------------------------------ ------------------------------------------------
      
      [Data Dictionary individual exceptions]
      
      
      [Application data individual exceptions]
      
      User  : FCHDBA
      Table : DTEC_ARCHIVE
      Column: CALL_REASON_ADDITIONAL
      Type  : VARCHAR2(100)
      Number of Exceptions         : 12
      Max Post Conversion Data Size: 103
      
      ROWID              Exception Type      Size      Cell Data(first 30 bytes)
      ------------------ ------------------ ----- ------------------------------
      AAAW7aAAEAAPb2uAAL exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
      L
      AAAW7aAAEAAPb6aAAi exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
      L
      AAAW7aAAEAAPbwaAAY exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
      L
      AAAW7aAAEAAPcMhAAS lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPcQJAAl lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPcQlAAf lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPcTlAAL lossy conversion         05120120001-B299 1.4 L DIESEL
      AAAW7aAAEAAPcYUAAB lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPcbnAAb lossy conversion         05120120001-B299 1.4 L DIESEL
      AAAW7aAAEAAPccFAAk lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPckDAAH lossy conversion         5120120001-B299 1.4 L DIESEL S
      AAAW7aAAEAAPcniAAU lossy conversion         05120120001-B299 1.4 L DIESEL
      ------------------ ------------------ ----- ------------------------------
      
      
      User  : FCHDBA
      Table : SERVICE_REQUEST_EMAIL_LOG
      Column: EMAIL_CONTENT
      Type  : CLOB
      Number of Exceptions         : 5369
      Max Post Conversion Data Size: 29896
      Thank you