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;
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;