oracle select invalid views
SELECT owner, object_type, object_name FROM all_objects WHERE status = 'INVALID'
Source: blog.devart.com
SELECT owner, object_type, object_name FROM all_objects WHERE status = 'INVALID'