由上一个分区表的问题，引出了另外一个问题ORA-14402
在update更新分区表的分区键的值的时候，需要开启row movement功能，否则会报错

ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change

HANMIDB SYS@ hanmi> conn hmbarcode/*******;

alter table barcode_master enable row movement;

update barcode_master set jejo_no = '16030003' where jepum_code = '1100000191' and jejo_no = '088615019' ;

update barcode_master_dtl set jejo_no = '16030003' where jepum_code = '1100000191' and jejo_no = '088615019' ;

alter table barcode_master disable row movement;

select TABLE_NAME,TABLESPACE_NAME,ROW_MOVEMENT from user_tables;

ITPub博客

解决ORA-14402: 更新分区关键字列将导致分区的更改

最新文章