Table of Contents
This chapter briefly introduces the UTL_RECOMP package, and describes how to use the procedures of the package.
UTL_RECOMP is used to recompile invalid objects including functions, procedures, views, triggers, packages, and types. This can only be used by a SYS user. Other DDLs cannot be executed while executing these procedures in Tibero since this can cause a deadlock to occur.
This section describes the procedure provided by the DBMS_ROWID package.
Recompiles invalid objects in order.
Details about the RECOMP_SERIAL procedure are as follows:
Prototype
PROCEDURE RECOMP_SERIAL ( schema IN VARCHAR2 DEFAULT NULL );
Parameter
| Parameter | Description |
|---|---|
| schema | Owner of the objects to recompile. If set to NULL, all invalid objects in the database are recompiled. |
Example
exec UTL_RECOMP.RECOMP_SERIAL(); /