Check Invalid Objects In Oracle

Buğra PARLAYAN

2 years ago

In today’s article we will learn How to See Invalid Object in Oracle Database.

We can See Invalid Object using the following code block.

SELECT OWNER
	,object_type
	,object_name
	,STATUS
FROM dba_objects
WHERE STATUS = 'INVALID'
ORDER BY OWNER
	,object_type
	,object_name;

SELECT OWNER

,object_type

,object_name

,STATUS

FROM dba_objects

WHERE STATUS = 'INVALID'

ORDER BY OWNER

,object_type

,object_name;