advanced code snippet search

Posted By

geekzspot on 02/09/13


Tagged


Versions (?)

Oracle find INVALID Objects

 / Published in: SQL
 

Find List Show See all objects such as Packages Procedures Functions Views that are INVALID

Expand | Embed | Plain Text 
  1. SELECT owner
  2.      , object_type
  3.      , object_name
  4.      , STATUS
  5.   FROM all_objects 
  6. WHERE STATUS != 'VALID'
  7.   AND owner = USER
  8. ORDER BY owner, object_type, object_name
  9. ;

Report this snippet  

You need to login to post a comment.