Space Manager with LiveReorg installation error ORA-01400 quest_spc_space_info.allocation_kb \spc_basic_stats_refresh.sql (4220049)

Unable to install Space Manager with LiveReorg as the installer returns ORA-01400

1. Determine whether issue is related to SAP objects with null values in the segment table, using query below:

select  s.owner, s.segment_name, s.segment_type

from  dba_segments s

inner join quest_spc_segments spcobj

on (s.owner = spcobj.owner

    and s.segment_name = spcobj.object_name

    and s.segment_type = spcobj.segment_type

    and nvl (s.partition_name, '"') = nvl (spcobj.subobject_name, '"'))

where s.bytes is null;

----  and ----

select  owner, segment_name, segment_type

from  dba_segments

where bytes is null;

2. If query result  returns segments owned by SAP owner, do the following:

- Go to the Space Manager installation folder under ~Space Manager 8.x \Install\SpaceManagerSchema directory

- Rename the spc_pkg_stat_calc.sql file

- Place the attached spc_pkg_stat_calc.sql file

- Start a SQL editor (Space Manager Editor, SQL*Plus, Toad, etc.)

- Login as the Space Manager owner

- Execute the attached spc_pkg_stat_calc.sql file

3. Retry the installation