CSSCAN fails with ORA-00600, CSS-00152, CSS-00120

Problem Description
While running csscan it fails with error message ORA-600, CSS-00152: failed to enumerate all tables and CSS-00120 as below.

$ csscan system/a FULL=Y FROMCHAR=WE8ISO8859P1 TOCHAR=WE8MSWIN1252 LOG=csscanwin1252
ARRAY=1000000 PROCESS=2


Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Sat Mar 7 21:10:05 2009

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


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

Enumerating tables to scan...
Warning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22)

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
CSS-00152: failed to enumerate all tables
CSS-00120: failed to enumerate tables to scan

Scanner terminated unsuccessfully.

Cause of the Problem
Scan fails because of the existence of tables in the recyclebin.

Solution of the Problem
1)Purge Recyclebin Objects: Query from dba_recyclebin and be sure you need those objects ever. If not purge them. To do this as sys as sysdba issue,

SQL>conn sys as sysdba

SQL>purge dba_recyclebin;

2)Run csscan again.
$ csscan system/a FULL=Y FROMCHAR=WE8ISO8859P1 TOCHAR=WE8MSWIN1252 LOG=csscanwin1252
ARRAY=1000000 PROCESS=2

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
ORA-00904: "CNVTYPE" CSS-08888: failed to update conversion type