|Oracle® Database SQL Language Reference
12c Release 1 (12.1)
|PDF · Mobi · ePub|
LIBRARY statement explicitly recompiles a library. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.
Note:This statement does not change the declaration or definition of an existing library. To redeclare or redefine a library, use the "CREATE LIBRARY" with the
If the library is in the
SYS schema, you must be connected as
SYSDBA. Otherwise, the library must be in your own schema or you must have the
LIBRARY system privilege.
library_compile_clause: See Oracle Database PL/SQL Language Reference for the syntax of this clause.)
Specify the schema containing the library. If you omit
schema, then Oracle Database assumes the procedure is in your own schema.
Specify the name of the library to be recompiled.
See Oracle Database PL/SQL Language Reference for the syntax and semantics of this clause and for complete information on creating and compiling libraries.
Use these clauses to specify whether the library becomes an editioned or noneditioned object if editioning is later enabled for the schema object type
schema. The default is
EDITIONABLE. For information about altering editioned and noneditioned objects, see Oracle Database Development Guide.