Monday, 13 July 2015

How to find invalid objects ?

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

No comments:

Post a Comment

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...