I have got this error message on upgraded system (Sat5.3 RHEL4 -> Sat5.5 RHEL6). I tried this command "db-control shrink-segments" after each step restore DB, /usr/share/spacewalk/setup/oracle/upgrade-db.sh and /usr/bin/spacewalk-schema-upgrade (all these commands finished OK) and I got different errors (with same file and number line /usr/share/perl5/vendor_perl/Dobby/DB.pm line 262). bash-4.1$ db-control shrink-segments Running segment advisor to find out shrinkable segments... WARNING: this may be a slow process. Shrinking recomended segments... RHN_PKG_CL_PID_N_TXT_TIME_UQ 233.4M reclaimable DBD::Oracle::db do failed: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO_TBS' (DBD ERROR: OCIStmtExecute) [for Statement "alter index "RHNSAT"."RHN_PKG_CL_PID_N_TXT_TIME_UQ" shrink space COMPACT"] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 262. .... DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) [for Statement "alter table "RHNSAT"."RHNPACKAGECHANGELOG" shrink space COMPACT"] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 262. .... DBD::Oracle::db do failed: ORA-01418: specified index does not exist (DBD ERROR: OCIStmtExecute) [for Statement "alter index "RHNSAT"."RHN_PKG_CL_PID_N_TXT_TIME_UQ" shrink space COMPACT"] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 262. INFO: -bash-4.1$ db-control report Tablespace Size Used Avail Use% DATA_TBS 4.3G 1.9G 2.4G 44% SYSAUX 500M 108.4M 391.5M 22% SYSTEM 400M 261.3M 138.6M 65% TEMP_TBS 1000M 0B 1000M 0% UNDO_TBS 1.9G 425.7M 1.5G 21% USERS 128M 64K 127.9M 0%
*** This bug has been marked as a duplicate of bug 918045 ***