Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E26088-02 |
|
|
PDF · Mobi · ePub |
The ALTER
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 theOR
REPLACE
clause.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 ALTER
ANY
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.