The relevant query is
as follows:
SELECT owner,
object_name, object_type
FROM all_objects
WHERE status = ‘INVALID’;
SELECT count(*)
FROM from dba_objects
WHERE status = ‘INVALID’;
Sunday, 5 February 2017
Subscribe to:
Post Comments (Atom)
Hey,
ReplyDeleteIn debt to you for making my learning on the Query to Check Database for Invalid Objects area so hassle-free! I lay my faith on your writings.
I've the attached table structure & data
From which I have a list of screen Ids from tbl_screen, and would like to get a list of users assigned, their privilege & access
Very useful post !everyone should learn and use it during their learning path.
Kind Regards,
Hansy