oracle select invalid views
snippet in sql

oracle select invalid views

user4582

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