The VALIDATE procedure is used to validate a specified object and change its status from INVALID to VALID.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_UTILITY.VALIDATE (
object_id IN NUMBER,
is_recompile IN BOOLEAN DEFAULT FALSE);
Parameters
Parameter |
Explanation |
|---|---|
| object_id | The ID of the object to be verified, corresponding to the data dictionary view.ALL_OBJECTSin theOBJECT_ID. |
| is_recompile | Whether to recompile the object. Default value:FALSE. |
Usage instructions
The VALIDATE procedure searches for the corresponding object in ALL_OBJECTS based on the object_id. If the specified object cannot be found, no action is performed.