Invalid Objects

To know about invalid objects

Select * from user_objects where status like 'INVALID';

 

Invalid objects  with their compilation commands with in a schema

      select     'ALTER ' || object_type || ' ' || object_name ||' COMPILE' || '; '    
                    SCRIPT_FOR_INVALID_COMPILATION
      from       user_objects
      where     status like 'INVALID';


a small thing we have to note is:

For  packages it will show commands to compile package & package body seperatley.

There is no seperate command for compiling package body.

For compiling PACKAGES use the below command

"alter package packag_name compile" (is enough).

*****************