COMPILE_SCHEMA procedure - Compile all functions, procedures, triggers, and packages in a schema

The COMPILE_SCHEMA procedure provides the capability to recompile all functions, procedures, triggers, and packages in a schema.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_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.