Oracle : Smart way to attack invalid objects for a schema


Try using this query to identify the approach to attack invalid objects in the schema


select referenced_name, count(referenced_name) cnt
  from user_dependencies
 where referenced_name in (select distinct object_name
                             from user_objects
                            where status =
 group by referenced_name
 order by cnt desc


 This will list down the objects in descending order on which maximum no. of invalid objects are dependent.

Leave a Reply

Your email address will not be published. Required fields are marked *