Oracle Invalid Objects

Çağlar Özenç

2 years ago

In today’s article, How Can I See Invalid Object in Oracle Database? I will be answering the question.

We can see with the help of the code block below.

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;