This discussion is archived
2 Replies Latest reply: May 16, 2012 1:01 AM by wzhang RSS

Character Set Migration using CSSCAN - Failed to scan table

937380 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points