oracle 更改分区列,ORA-14061: 不能更改索引分区列的数据类型或长度

修改分区表主键时报错：

在行: 2 上开始执行命令时出错 -

alter table KC23 modify AAZ210 VARCHAR2(50)

错误报告 -

SQL 错误: ORA-14061: 不能更改索引分区列的数据类型或长度

14061. 00000 -  "data type or length of an index partitioning column may not be changed"

*Cause:    User issued ALTER TABLE statement attempting to modify

data type and/or length of a column used to partition some index

defined on the table named in ALTER TABLE statement, which is

illegal

*Action:   Avoid modifying data type and/or length of index

partitioning column(s)

--解决：

ALTER TABLE KC23 drop CONSTRAINT PK_KC23;

drop index PK_KC23;

alter table KC23 modify ( AAZ210 VARCHAR2(50));

alter table KC23 add constraint PK_KC23 primary key(AAZ210) using index TABLESPACE TBSB_SJQY;

ALTER TABLE KC23 enable CONSTRAINT PK_KC23;

内容来源于网络如有侵权请私信删除