Thursday, 26 November 2015

How to find invalid objects and syntax to compile?

set pages 1000
set lines 1000
select 'alter ' || OBJECT_TYPE || ' '  ||OWNER|| '.' ||object_name||   ' COMPILE;'   FROM dba_objects where OBJECT_TYPE != 'PACKAGE BODY' and status='INVALID' order by OBJECT_TYPE;

select 'alter PACKAGE '  ||OWNER|| '.' ||object_name||   ' COMPILE BODY;'   FROM dba_objects where OBJECT_TYPE = 'PACKAGE BODY' and status='INVALID';

No comments:

Post a Comment