Sunday, 31 January 2016

Find Invalid Objects in Oralce


SQL> select count(*) from dba_objects where status='INVALID';


select owner, object_name, object_type from dba_objects where status = 'INVALID' order by 1,2,3;

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------ -------------------
FLEETAUTN            AD_BATCH_PKG                   PACKAGE BODY
SYSMAN               UPDATE_SOURCE                  TRIGGER
SYSMAN               WEBAPP_UPGRADE                 PACKAGE
SYSMAN               WEBAPP_UPGRADE_JOB             PACKAGE


======

No comments:

Post a Comment