The subprogram CLEAR_TABLEGROUP_BALANCE_WEIGHT is used to delete the weights of a table group of type SHARDING NONE.
Syntax
DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT(
tablegroup_name VARCHAR(65535)
);
Parameters
Parameter |
Description |
|---|---|
| tablegroup_name | Table group name. |
Usage instructions
The DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT statement is used to delete the weight of a table group with the specified name in sharding none mode.
Examples
Call in the sys tenant to drop the weight of the table group
TG_TD_testunder themysqltenant.obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test') TENANT = 'mysql';Delete the weight of the table group
TG_TD_testunder the current tenant when called by a user tenant.obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test');
References
- For information about setting the weights of a
SHARDING NONEtable group, see SET_TABLEGROUP_BALANCE_WEIGHT. - For information about querying the weights of each table group, see oceanbase.CDB_OB_DATABASES or oceanbase.DBA_OB_DATABASES.