Error calculating reorg need for tablespace <tablespace_name> (ora-06502: PL/SQL: numeric or value error
ora-06512: at "xxx.QUEST_SPC_ANALYSIS_TASKS", line 174
ora-06512: at "xxx.QUEST.SPC_CALC_REORG_NEED", line 958
ora-06512: at line 1)
This happens when a table has a lot of LOB columns and/or with long names.
Try installing the attached packages and retry.
1. You need to Rename the current spc_pkg_reorg_need_body90.plb and spc_pkg_analysis_tasks90.sql in space manager Install folder
2. Copy the attached into the install folder
3. Log on to space manager as the installing user
4. Open each of the files and execute them
5. Check in dba_objects that the packages are valid.
6. Retry.
