The RESET_GLOBAL_PREF_DEFAULTS procedure resets global preferences to their default values.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_STATS.RESET_GLOBAL_PREF_DEFAULTS;
Examples
Reset all global preferences to default values.
obclient> CALL DBMS_STATS.RESET_GLOBAL_PREF_DEFAULTS();
Query OK, 0 rows affected