set pages 1000
spool compile_inv
select ‘alter ‘ || object_type || ‘ ‘ || object_name || ‘ compile; ‘
from user_objects
where status = ‘INVALID’;
spool off
set pages 1000
spool compile_inv
select ‘alter ‘ || object_type || ‘ ‘ || object_name || ‘ compile; ‘
from user_objects
where status = ‘INVALID’;
spool off