Friday, 27 July 2012

Manual compilation of INVALID objects in Oracle

#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;

No comments:

Post a Comment