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 :

2 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
  2. 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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete