How to Check Invalid Objects Count in Oracle

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

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