After upgrade to Satellite v5.5, getting errors " ORA-00942: table or view does not exist ". How do we fix it?
Issue
- After upgrade to Satellite v5.5, getting errors " ORA-00942: table or view does not exist ". How do we fix it?
$ /sbin/runuser oracle -c "db-control shrink-segments"
Running segment advisor to find out shrinkable segments...
WARNING: this may be a slow process.
Shrinking recomended segments...
RHNPACKAGECHANGELOG 222.8M reclaimable
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.
- After upgrade to v5.5 satellite several tables were dropped but the table appears in the schema with the WinDOS tool used to query the database
- When we browse for data using WinDOS tool, weI get an error :
Browse data generated an error.
ORA-00942: table or view does not exist
Environment
- RHN Satellite v5.5 (post-upgrade)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.