set heading off
spool compileinvalid.sql
select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects
where status='INVALID';
spool off
select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects
where status='VALID';
set heading off
spool compileinvalid.sql
select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects
where status='INVALID';
spool off
select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects
where status='VALID';