本文将为您描述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;ORA-14061: 不能更改索引分区列的数据类型或长度就为您介绍到这里，感谢您关注懒咪学编程c.lanmit.com.

本文地址：https://c.lanmit.com/shujuku/Oracle/24524.html