The COMPILE_SCHEMA procedure provides the capability to
recompile all functions, procedures, triggers, and packages in a schema.
Syntax
>>-DBMS_UTILITY.COMPILE_SCHEMA--(--schema--+---------------------------------------+-->
'-,--compile_all--+-------------------+-'
'-,--reuse_settings-'
>--)-----------------------------------------------------------><
Parameters
- schema
- An input argument of type VARCHAR(128) that specifies the schema
in which the programs are to be recompiled.
- compile_all
- An optional input argument of type BOOLEAN that must be set to false,
meaning that the procedure only recompiles programs currently in invalid
state.
- reuse_settings
- An optional input argument of type BOOLEAN that must be set to false,
meaning that the procedure uses the current session settings.
Authorization
EXECUTE privilege on the DBMS_UTILITY
module.