Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query To Find Dependent Objects Of An Invalid Object

The relevant query is as follows:

SELECT owner, object_type, object_name
FROM     dba_objects
WHERE  status = ‘INVALID’
AND       object_name IN (SELECT referenced_name
                                                               FROM    dba_dependencies
                                                               WHERE  name = ‘<INVALID_OBJECT_NAME>’);


This will bring results down only one level of dependencies.
Share this article :

0 comments:

Post a Comment