Search 800 + Posts

Apr 8, 2014

Query to get Invalid Object in Oracle database



select * from all_objects
where status ='INVALID'
--and object_name like 'Enter_object_name%'


select * from DBA_objects
where status ='INVALID'
--and object_name like 'Enter_object_name%'

No comments:

Post a Comment