解決ORA-14402: 更新分割槽關鍵字列將導致分割槽的更改

由上一個分割槽表的問題，引出了另外一個問題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;