2 Replies Latest reply: May 16, 2012 3:01 AM by wzhang-Oracle RSS

    Character Set Migration using CSSCAN - Failed to scan table

    937380
      Dear,

      I'm planning to perform a Character Set Migration. Currently I try to run the csscan, but it always fails within one special table.

      csscan \"sys/sys+xxxx_yyy@yyy as sysdba\" USER=test TABLE=test.T_SOD_EXCEPTIONS_HIST TOCHAR=AL32UTF8 ARRAY=102400000 PROCESS=8 log=test_20120514.log


      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options

      Enumerating table to scan...

      . process 1 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAApAAB7oAAAA]
      . process 2 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAARAAC6yJAAA]
      . process 3 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAYAAA4CAAAA]
      . process 4 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAnAABFiAAAA]
      . process 5 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAhAAIgyAAAA]
      . process 7 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAUAACRCAAAA]
      . process 8 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAA0AAEXQAAAA]
      . process 6 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAArAAA7WAAAA]
      . process 4 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAtAABdUAAAA]
      . process 5 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAJAACewAAAA]
      . process 2 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAaAABXuAAAA]
      . process 1 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAA1AAHmcAAAA]
      . process 8 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAXAADbcAAAA]
      . process 3 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAVAAAwcAAAA]
      . process 7 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAyAACV0AAAA]
      . process 6 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAbAAACyAAAA]
      . process 5 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAGAAAnUJAAA]
      . process 4 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAAcAAADeAAAA]
      . process 8 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAA4AABCgAAAA]
      . process 7 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAA3AAB1WAAAA]
      . process 1 scanning CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST[AABj/MAA2AAATqAAAA]
      ORA-03113: end-of-file on communication channel
      Process ID: 23837
      Session ID: 3 Serial number: 63263

      CSS-00144: failed to scan table CIO_P2PSOD.T_SOD_EXCEPTIONS_HIST

      Do anybody know what could be the reason? A corrupt record .. !? Please help me out ...

      Many Thanks
      Stefan