Monday, 13 July 2015

How to find invalid objects ?

select object_name,
          object_type
         ,owner
         ,status
from dba_objects
where status='Invalid';
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...