Site icon Bugra Parlayan | Oracle Database Blog

How Can I See Invalid Object In Oracle Database

Q : How Can I See Oracle Invalid Object

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