VALIDATE is used to validate or recompile a single database object.
Applicability
This content applies only to the Oracle-compatible mode of OceanBase Database.
Syntax
DBMS_UTILITY.VALIDATE(
OBJECT_ID NUMBER,
IS_RECOMPILE BOOLEAN DEFAULT FALSE);
Parameters
| Parameter | Description |
|---|---|
| OBJECT_ID | The ID of the database object. |
| IS_RECOMPILE | The flag indicating whether to recompile the object in the background. This flag does not need to be set. Keep it as false. |
Examples
obclient> BEGIN
DBMS_UTILITY.VALIDATE(52939)
END;