Compile invalid objects for a particular schema

 select 'alter '||decode(object_type,'PACKAGE BODY','PACKAGE','UNDEFINED','MATERIALIZED VIEW',object_type)||' '||object_name||' compile;' from dba_objects where status='INVALID' and owner= '&TB';