How to re-Compile Invalid Objects (Package, Function, Procedure, View, Trigger)

Step 1. Create sql file as compile.sql in shell and content as below:

connect &1/&2

set pages 1000
set head off
set feedback off

spool compile1.sql
prompt set feedback on
select 'alter '||decode(object_type,'PACKAGE BODY',
    'PACKAGE',object_type)||' '||object_name||' '||
     decode(object_type,'PACKAGE BODY','compile body','compile')||';'
from user_objects
where status='INVALID'
/
spool off
@compile1.sql


Step 2. Login Oracle by sqlplus:

#sqlplus / as sysdba

Step 3. execute sql file:

> @compile.sql