CLEAR_TABLEGROUP_BALANCE_WEIGHT

The CLEAR_TABLEGROUP_BALANCE_WEIGHT procedure is used to delete the weights of a table group of the SHARDING NONE type.

Syntax

DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT(
    tablegroup_name       VARCHAR(65535)
    ); 

Parameters

Considerations

Call DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT to delete the weights of a sharding none table group.

Examples

• Call this procedure in the sys tenant to delete the weights of the TG_TD_test table group in the mysql tenant.

  obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test') TENANT = 'mysql';
  

• Call this procedure in a user tenant to delete the weights of the TG_TD_test table group in the current tenant.

  obclient> CALL DBMS_BALANCE.CLEAR_TABLEGROUP_BALANCE_WEIGHT('TG_TD_test');
  

References

• For more information about how to set the weights of a table group of the SHARDING NONE type, see SET_TABLEGROUP_BALANCE_WEIGHT.
• For more information about how to query the weights of a table group, see oceanbase.CDB_OB_DATABASES or oceanbase.DBA_OB_DATABASES.