Bizinsight Consulting Blog
Business Applications and Integration Blog
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
‹
›
Home
View web version
No comments:
Post a Comment