Showing posts with label oracle invalid objects. Show all posts
Showing posts with label oracle invalid objects. Show all posts

Tuesday, October 27, 2009

Oracle Invalid Objects

Here is a quick query for Oracle users to identify all invalid objects:

SELECT owner,object_name,object_type
FROM dba_objects WHERE status='INVALID'