Saturday, March 7, 2009

CSSCAN fails with CSS-00151: failed to enumerate user tables CSS-00120

Problem Description
While running csscan it fails with ORA-00942, CSS-00151 and CSS-00120 as below.

$ csscan user=prod2 tochar=AL32UTF8 ARRAY=1024000 process=4

Character Set Scanner v2.1 : Release 10.2.0.3.0 - Production on Sat Mar 7 20:27:08 2009

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

Username:system

Password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Enumerating tables to scan...

ORA-00942: table or view does not exist
CSS-00151: failed to enumerate user tables
CSS-00120: failed to enumerate tables to scan

Scanner terminated unsuccessfully

Solution of the Problem
I found no where the solution of the problem. But I noticed that re-running the $ORACLE_HOME/rdbms/admin/csminst.sql script would solve the problem. Re-running the csminst.sql will drop the csmig user and re-create the csmig user. So, in order to solute the problem,
1)connect to database sys as sysdba.
$sqlplus / as sysdba

2)Run the csminstl.sql
SQL>@$ORACLE_HOME/rdbms/admin/csminst.sql

3)Re-run the csscan.
$ csscan user=prod2 tochar=AL32UTF8 ARRAY=1024000 process=4

Related Documents
Difference between WE8MSWIN1252 and WE8ISO8859P15 characterset
Difference between WE8ISO8859P1 and WE8ISO8859P15 characterset
Difference between WE8ISO8859P1 and WE8MSWIN1252 characterset

No comments:

Post a Comment