Bizinsight Consulting Blog
Business Applications and Integration Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment