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';
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