--- title: "修改随机分布表 - OceanBase 数据库 V5.0.1 | OceanBase 文档中心" description: 修改随机分布表 本文将向您介绍如何使用 SQL 语句修改随机分布表。 权限要求 修改修改随机分布表需要有 ALTER 权限。更多有关 OceanBase 数据库权限的详细介绍，参见 MySQL 模式下的权限分类 。 语法 修改随机分布表的 SQL 语句格式如下： ALTER TABLE table_name PART… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 5.0.1 # 修改随机分布表 更新时间：2026-07-29 10:39:51 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V5.0.1/zh-CN/700.reference/300.database-object-management/100.manage-object-of-mysql-mode/300.manage-partitions-of-mysql-mode/270.random-partition-table-of-mysql-mode/400.modify-random-partition-table-of-mysql-mode.md) 本文将向您介绍如何使用 SQL 语句修改随机分布表。 ## 权限要求 修改修改随机分布表需要有 `ALTER` 权限。更多有关 OceanBase 数据库权限的详细介绍，参见 [MySQL 模式下的权限分类](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000006619040)。 ## 语法 修改随机分布表的 SQL 语句格式如下： ```sql ALTER TABLE table_name PARTITION BY RANDOM SIZE('size_value'); ``` ## 动态分区管理属性参数说明 | **参数** | **描述** | | --- | --- | | table_name | 表名称。 | | SIZE('size_value') | 用于修改随机分布表每个分区的数据容量阈值，超出后触发自动新增分区。取值范围 [1MB, +∞)，支持 `MB`、`GB` 等单位。 | 更多有关修改表语法的详细参数说明信息，参见 [ALTER TABLE](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000006619416)。 ## 示例 1. 创建随机分布表 `tbl1`，并指定分区大小为 2GB。 ```shell obclient> CREATE TABLE tbl1( col1 INT, col2 DATETIME, col3 VARCHAR(1024) ) PARTITION BY RANDOM SIZE('2GB'); ``` 2. 查看表 `tbl1` 的定义信息。 ```shell obclient> SHOW CREATE TABLE tbl1; ``` 查询结果如下： ```shell +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tbl1 | CREATE TABLE `tbl1` ( `col1` int(11) DEFAULT NULL, `col2` datetime DEFAULT NULL, `col3` varchar(1024) DEFAULT NULL ) ORGANIZATION INDEX DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 partition by random size ('2048MB') | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set ``` 3. 修改随机分布表 `tbl1` 的分区大小为 8GB。 ```sql obclient> ALTER TABLE tbl1 PARTITION BY RANDOM SIZE('8GB'); ``` 4. 再次查看表 `test_tbl1` 的定义信息。 ``` 查询结果如下： ```shell +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tbl1 | CREATE TABLE `tbl1` ( `col1` int(11) DEFAULT NULL, `col2` datetime DEFAULT NULL, `col3` varchar(1024) DEFAULT NULL ) ORGANIZATION INDEX DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 partition by random size ('8192MB') | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set ``` ## 相关文档 - [随机分布表概述](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000006619147) - [创建随机分布表](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000006619148) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线