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

Pages

Sunday, 5 February 2017

Query to Check Database for Invalid Objects


The relevant query is as follows:

SELECT owner, object_name, object_type
FROM     all_objects
WHERE  status = ‘INVALID’;

SELECT count(*)
FROM   from dba_objects
WHERE  status = ‘INVALID’;



Share this article :

1 comments:

  1. Hey,


    In debt to you for making my learning on the Query to Check Database for Invalid Objects area so hassle-free! I lay my faith on your writings.

    I've the attached table structure & data
    From which I have a list of screen Ids from tbl_screen, and would like to get a list of users assigned, their privilege & access

    Very useful post !everyone should learn and use it during their learning path.


    Kind Regards,
    Hansy

    ReplyDelete