The POPULATE_UTL_RECOMP_SKIP_LIST procedure is used to collect invalid objects in the current system, which will be skipped during subsequent compilations.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
UTL_RECOMP.POPULATE_UTL_RECOMP_SKIP_LIST(
schema IN VARCHAR2 DEFAULT NULL,
object IN VARCHAR2 DEFAULT NULL,
flags IN PLS_INTEGER DEFAULT 0
);
Parameters
| Parameter | Description |
|---|---|
| schema | The name of the schema where the database object to be skipped during recompilation is located. |
| object | The name of the database object to be skipped during recompilation. |
| flags | This parameter is effective only when a table with the same name exists. A value of 512 indicates that if a table with the same name exists in the SYS tenant, it will be used directly. A value of 1024 indicates that if a table with the same name exists, it will be dropped and automatically recreated. The default value is 0 (optional), which has no special meaning. |
Examples
EXECUTE UTL_RECOMP.POPULATE_UTL_RECOMP_SKIP_LIST();
Query OK, 1 row affected (23.463 sec)