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’;
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Home » APPS QUERIES » Query to Check Database for Invalid Objects
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
I invite you to the page where you can keep with puzzling information on close district. visit this url
ReplyDelete