The POPULATE_UTL_RECOMP_SKIP_LIST procedure collects invalid objects in the current system. These invalid objects are skipped in recompilation.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
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 in recompilation resides. |
| object | The name of the database object to be skipped in recompilation. |
| flags | The action to take if a table with the same name already exists. If a table with the same name already exists in the sys tenant, the value 512 specifies to directly use the table, and the value 1024 specifies to directly drop the table and create a new one. The default value is 0, which is optional and has no special meanings. |
Examples
EXECUTE UTL_RECOMP.POPULATE_UTL_RECOMP_SKIP_LIST();
Query OK, 1 row affected (23.463 sec)