---
title: "通过 alter table 修改分区规则时，遇到报错：Too many fields in 'list of partition fields' 的原因和解决方法-OceanBase数据库使用指南"
description: "了解OceanBase数据库在实际应用中关于通过 alter table 修改分区规则时，遇到报错：Too many fields in 'list of partition fields' 的原因和解决方法相关的常见问题和使用技巧，帮助您快速解决通过 alter table 修改分区规则时，遇到报错：Too many fields in 'list of partition fields' 的原因和解决方法的难题。"
---
切换语言

- 简体中文
- English

划线反馈

# 通过 alter table 修改分区规则时，遇到报错：Too many fields in 'list of partition fields' 的原因和解决方法

更新时间：2026-05-21 09:16

适用版本： V4.0.x、V4.1.x、V4.2.x、V4.3.x 内容类型：Troubleshoot  

## 问题现象

- OceanBase 数据库 MySQL 模式修改分区规则报错 `ERROR 1655 (HY000): Too many fields in 'list of partition fields'`。

  ```shell
  obclient(root@mysqlt)[testdb]> show create table test_num;
  +----------+---------------------------------------------------------------------------+
  | Table    | Create Table       |
  +----------+---------------------------------------------------------------------------+
  | test_num | CREATE TABLE `test_num` (
  `a1` varchar(20) NOT NULL,
  `a2` int(11) NOT NULL,
  `a3` varchar(20) NOT NULL,
  `a4` varchar(1) NOT NULL,
  `a5` varchar(1) NOT NULL,
  `a6` varchar(30) NOT NULL,
  `a7` varchar(1) NOT NULL,
  `a8` varchar(1) NOT NULL,
  `a9` varchar(1) NOT NULL,
  `a10` varchar(30) NOT NULL,
  `a11` varchar(30) NOT NULL,
  `a12` varchar(30) NOT NULL,
  `a13` varchar(2) NOT NULL,
  `a14` varchar(2) NOT NULL,
  `a15` varchar(10) NOT NULL,
  `a16` varchar(3) NOT NULL,
  `a17` varchar(4) NOT NULL
  ) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 |
  +----------+----------------+
  1 row in set (0.004 sec)

   obclient(root@mysqlt)[testdb]> alter table test_num partition by key (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) partitions 32;
    ERROR 1655 (HY000): Too many fields in 'list of partition fields'

  ```
 - OceanBase 数据库 Oracle 模式下修改分区规则报错 `ORA-00600: internal error code, arguments: -5287, Too many fields in 'list of partition fields'`。

  ```shell
  obclient(SYS@oracle)[SYS]> show create table test_num;
  +----------+---------------------------------------------------------------------------+
  | TABLE    | CREATE TABLE
  +----------+---------------------------------------------------------------------------+
  | TEST_NUM | CREATE TABLE "TEST_NUM" (
  "A1" VARCHAR2(20) NOT NULL ENABLE,
  "A2" NUMBER(*,0) NOT NULL ENABLE,
  "A3" VARCHAR2(20) NOT NULL ENABLE,
  "A4" VARCHAR2(1) NOT NULL ENABLE,
  "A5" VARCHAR2(1) NOT NULL ENABLE,
  "A6" VARCHAR2(30) NOT NULL ENABLE,
  "A7" VARCHAR2(1) NOT NULL ENABLE,
  "A8" VARCHAR2(1) NOT NULL ENABLE,
  "A9" VARCHAR2(1) NOT NULL ENABLE,
  "A10" VARCHAR2(30) NOT NULL ENABLE,
  "A11" VARCHAR2(30) NOT NULL ENABLE,
  "A12" VARCHAR2(30) NOT NULL ENABLE,
  "A13" VARCHAR2(2) NOT NULL ENABLE,
  "A14" VARCHAR2(2) NOT NULL ENABLE,
  "A15" VARCHAR2(10) NOT NULL ENABLE,
  "A16" VARCHAR2(3) NOT NULL ENABLE,
  "A17" VARCHAR2(4) NOT NULL ENABLE
  ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384   USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 |
   +----------+---------------------------------------------------------------------------+
   1 row in set (0.037 sec)

   obclient(SYS@oracle)[SYS]> ALTER TABLE test_num MODIFY PARTITION BY HASH (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) PARTITIONS 32;
   ORA-00600: internal error code, arguments: -5287, Too many fields in 'list of partition fields'

  ```

## 问题原因

目前内核设定了最大分区键只有 16 个，并且没有接口可以修改这个值。以上案例中，分区中的字段列数超过 16 个，因此报错。

## 适用版本

OceanBase 数据库 V4.x 版本。

## 解决方法

修改分区规则时，控制分区中的字段列数在 16 个以内。

- OceanBase 数据库 MySQL 模式修改分区规则成功。

  ```shell
  obclient(root@mysqlt)[testdb]> alter table test_num partition by key (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) partitions 32;
  Query OK, 0 rows affected (1.823 sec)

  ```
 - OceanBase 数据库 Oracle 模式修改分区规则成功。

  ```shell
  obclient(SYS@oracle)[SYS]> ALTER TABLE test_num MODIFY PARTITION BY HASH (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) PARTITIONS 32;
  Query OK, 0 rows affected (2.693 sec)

  ```

Previous

[truncate table 数据后如何恢复](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000004752750)

Next

[table_id 的含义](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000207757) ![有帮助](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) 咨询热线