ORA-00904: "CNVTYPE" CSS-08888: failed to update conversion type

Problem Description
To check all character data in the database and tests for the effects and problems of changing the character set encoding we ran csscan before character set migration but csscan fails with
ORA-00904: "CNVTYPE": invalid identifier

CSS-08888: failed to update conversion type

as below.

C:\>csscan arju/a@orcl user=arju process=2 array=1024000 TOCHAR=AL32UTF8


Character Set Scanner v2.2 : Release 11.1.0.6.0 - Production on Tue Feb 3 17:15:46 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Enumerating tables to scan...

. process 1 scanning ARJU.TEST_VARCHAR[AAAaieAAEAAAPiBAAA]
ORA-00904: "CNVTYPE": invalid identifier

CSS-08888: failed to update conversion type

Scanner terminated unsuccessfully.
Cause of the problem
The ORA-00904: "CNVTYPE": invalid identifier in csscan occurred due to version mismatch between csscan utility and database. From the above output we see Character Set Scanner v2.2 : Release 11.1.0.6.0 that is csscan version is 2.2 and it is of release 11g while it connects to database 10.2g. In order to connect to oracle database 10g it is recommended to use csscan tool of version 2.1. Hence we connect 10.2g database with 11g csscan so above error comes.

Solution of the problem
In order to connect to 10.2g database use 10.2g csscan that is csscan of version 2.1. So from 10g ORACLE_HOME I explicitly selected csscan of version 2.1 and run the operation which goes successful.

C:\>j:\oracle\product\10.2.0\db_1\BIN\csscan.exe arju/a@orcl user=arju process=2 array=1024000 TOCHAR=AL32UTF8


Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Tue Feb 3 17:30:02 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Enumerating tables to scan...
. process 1 scanning ARJU.TEST_VARCHAR[AAAaieAAEAAAPiBAAA]

Creating Database Scan Summary Report...

Creating Individual Exception Report...

Scanner terminated successfully.

Related Documents
CSSCAN fails with CSS-00151: failed to enumerate user tables CSS-00120
CSSCAN fails with error while loading shared libraries: libclntsh.so.10.1
How to run csscan in the background as a sysdba
CSSCAN fails with CSS-00107: Character set migration utility schema not installed
CSSCAN fails with ORA-00600, CSS-00152, CSS-00120