Press "Enter" to skip to content

How to Check Invalid Objects Count in Oracle

Use dba_objects or user_objects dictionary view to count invalid objects in Oracle.

1. Count Invalid Objects in Oracle Using dba_objects

SELECT COUNT ( * ) invalid_objects
FROM dba_objects
WHERE owner = USER AND status = 'INVALID';

2. Count Invalid Objects in Oracle Using user_objects

SELECT COUNT ( * ) invalid_objects
FROM user_objects
WHERE status = 'INVALID';

See also:

  1. How to Create a Procedure Inside a Package in Oracle
  2. Download Oracle Scott Schema Script

Vinish Kapoor

I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me, it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub and get notifications for new posts.

You may also like:

Be First to Comment

    Leave a Reply

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