Compile invalid objects - Oracle Database Script. -- To compile all objects in database @$ORACLE_HOME/rdbms/admin/utlrp.sql -- Compile objects of a particular schema: EXEC DBMS_UTILITY.compile_schema(schema => 'APPS'); -- Compiling a package; ALTER PACKAGE APPS.DAIL_REPORT COMPILE; ALTER PACKAGE APPS.DAIL_REPORT COMPILE BODY; -- Compiling a procedure: ALTER PROCEDURE APPS.REPORT_PROC COMPILE; -- Compiling a view: ALTER VIEW APPS.USERSTATUS_VW COMPILE; -- Compiling a function: ALTER FUNCTION APPS.SYNC_FUN COMPILE;
-- To compile all objects in database @$ORACLE_HOME/rdbms/admin/utlrp.sql -- Compile objects of a particular schema: EXEC DBMS_UTILITY.compile_schema(schema => 'APPS'); -- Compiling a package; ALTER PACKAGE APPS.DAIL_REPORT COMPILE; ALTER PACKAGE APPS.DAIL_REPORT COMPILE BODY; -- Compiling a procedure: ALTER PROCEDURE APPS.REPORT_PROC COMPILE; -- Compiling a view: ALTER VIEW APPS.USERSTATUS_VW COMPILE; -- Compiling a function: ALTER FUNCTION APPS.SYNC_FUN COMPILE;