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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
