The OB_INIT_OBJECTS procedure creates a data statistical table under the schema user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
PROCEDURE OB_INIT_OBJECTS(force_create IN boolean :=FALSE);
Parameters
| Parameter | Description |
|---|---|
| force_create IN boolean : =FALSE | FALSE, the system returns an error and exits if a table with the same name already exists.TRUE, if a table with the same name already exists, the system drops the table and creates it again. The default value is FALSE. |
Examples
obclient> call dbms_profiler.ob_init_objects();
Query OK, 0 rows affected (0.06 sec)