Site icon Bugra Parlayan | Oracle Database Blog

How can i see Invalid Object in Oracle Database

Q : How can i see Invalid Object in Oracle Database

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