Compile Invalid Objects

We can use below commands to compile all invalid objects except indexes and lob objects.

RAC / NON-RAC / Cloud RDS:

PACKAGE:

alter package <owner>.<package_name> compile;

PACKAGE BODY:

alter package <owner>.<package_name> compile body;

PROCEDURE:

alter procedure <owner>.<procedure_name> compile;

FUNCTION:

alter function <owner>.<function_name> compile;

TRIGGER:

alter trigger <owner>.<trigger_name> compile;

VIEW:

alter view <owner>.<view_name> compile;