#TO Compile Package
ALTER PACKAGE schema.package COMPILE;
#To Compile Package Body
ALTER PACKAGE schema.package COMPILE BODY;
#To Compile Synonym
ALTER SYNONYM schema.synonym compile;
#To Compile Procedure
ALTER PROCEDURE schema.procedure COMPILE;
#To compile Function
ALTER FUNCTION schema.function COMPILE;
#To Compile Trigger
ALTER TRIGGER my_trigger COMPILE;
#To Compile View
ALTER VIEW schema.view COMPILE;
#To Compile Materialized view
ALTER MATERIALIZED VIEW schema.view compile;
#To Compile Public Synonym
ALTER PUBLIC SYNONYM my_synonym compile;
