Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


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 :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.