Home » RDBMS Server » Server Administration » Invalid objects and ORA-00942 error
Invalid objects and ORA-00942 error [message #279440] Thu, 08 November 2007 07:52 Go to next message
gatsby
Messages: 21
Registered: March 2006
Junior Member
Hello -

I recently upgraded my Oracle database from 9.2.0.7 to 9.2.0.8. The patchset seemingly applied without problem, and I performed all post-installation tasks as normal. I then applied the October 2007 CPU, and after running utlrp.sql, I continued to get a number of invalid objects. Before applying the patch, there were no errors.

Upon closer examination, all the invalid objects are views that give the error "ORA-00942: table or view does not exist". I rolled back the October 2007 CPU, but that did not solve the problem.

Has anyone experienced this before or might have some suggestions?

Thanks in advance.
Re: Invalid objects and ORA-00942 error [message #279442 is a reply to message #279440] Thu, 08 November 2007 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In which schema(s) are these objects?

"ORA-00942: table or view does not exist" means either the table does not exist or the user does not have direct access on it.
Investigate which schema owns this/these table/s.

Regards
Michel
Re: Invalid objects and ORA-00942 error [message #279631 is a reply to message #279440] Fri, 09 November 2007 07:54 Go to previous messageGo to next message
gatsby
Messages: 21
Registered: March 2006
Junior Member
The tables that these views referenced seem no longer to exist in the database. I suppose the patchset dropped the tables and not the views related to them.
Re: Invalid objects and ORA-00942 error [message #279824 is a reply to message #279440] Sat, 10 November 2007 19:34 Go to previous message
gatsby
Messages: 21
Registered: March 2006
Junior Member
These invalid views are actually left over from the Oracle 8i Enterprise Manager, which we upgraded from awhile back.

[Updated on: Sat, 10 November 2007 19:37]

Report message to a moderator

Previous Topic: Rebuliding index issue
Next Topic: buffel_pool
Goto Forum:
  


Current Time: Thu Dec 08 06:11:33 CST 2016

Total time taken to generate the page: 0.21803 seconds