Showing posts with label System Tables. Show all posts
Showing posts with label System Tables. Show all posts

Monday, August 23, 2010

How do you find the invalid objects in your schema?

SELECT   object_name,
         object_type,
         created,
         last_ddl_time,
         status
  FROM   user_objects
 WHERE   status != 'VALID'