The CLEAR_TABLEGROUP_BALANCE_WEIGHT procedure is used to delete the weight of a SHARDING NONE tablegroup.
Note
This procedure is supported starting from V4.4.1.
Syntax
DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT(
tablegroup_name VARCHAR(65535)
);
Parameters
| Parameter | Description |
|---|---|
| tablegroup_name | The name of the tablegroup. |
Considerations
Call DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT and specify the name of the tablegroup to delete the weight of the SHARDING NONE tablegroup.
Examples
Call this procedure in the sys tenant to delete the weight of the
TG_TD_testtablegroup in themysqltenant.obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test') TENANT = 'mysql';Call this procedure in a user tenant to delete the weight of the
TG_TD_testtablegroup in the current tenant.obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test');
References
- For more information about how to set the weight of a
SHARDING NONEtablegroup, see SET_TABLEGROUP_BALANCE_WEIGHT. - For more information about how to query the weight of a tablegroup, see oceanbase.CDB_OB_DATABASES or oceanbase.DBA_OB_DATABASES.