由上一个分区表的问题,引出了另外一个问题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;
在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博客 ” ,链接:http://blog.itpub.net/27036311/viewspace-2121944/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27036311/viewspace-2121944/