alter table tb_wz_pmd enable row movement; //打开分区记录移动
alter table tb_wz_pmd disable row movement;//关闭分区记录移动
这用于将一个分区的数据修改为其他分区,否则会报错:ORA-14402: updating partition key column would cause a partition change
修改后可以执行sql:
update tb_job set partid=TO_CHAR(TO_DATE('2012-01-09', 'yyyy-mm-dd'), 'dd');
alter table tb_wz_pmd disable row movement;//关闭分区记录移动
这用于将一个分区的数据修改为其他分区,否则会报错:ORA-14402: updating partition key column would cause a partition change
修改后可以执行sql:
update tb_job set partid=TO_CHAR(TO_DATE('2012-01-09', 'yyyy-mm-dd'), 'dd');