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;