rem ----------------------------------------------------------------------- rem Filename: cmpall.sql rem Purpose: Compile all invalid database objects in a schema rem Run this script after each database upgrade or whenever rem required. rem Notes: This script akes quite a while to run. Use it after changes rem in a package to recompile the dependent packages. rem Date: 23-Jan-1999 rem Author: Kai-Hagen Wirth rem ----------------------------------------------------------------------- -- Change to the owner of the Objects that must be compiled. -- ^ ^ -- | | EXEC DBMS_UTILITY.COMPILE_SCHEMA( 'schema-name' ); -- -- Later releases of Oracle also includes a script to recompile invalid objects: -- SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql --