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