更新分区字段的时候需要enable row movement

SQL> select Distinct monthno
  2  from oss_actv_point_mon_list a;

   MONTHNO                                                                     
----------                                                                     
    201102                                                                     

SQL> Update oss_actv_point_mon_list
  2    Set monthno = 201105
  3   Where monthno=201102;
Update oss_actv_point_mon_list
       *
第 1 行出现错误:
ORA-14402: updating partition key column would cause a partition change

SQL> Alter Table oss_actv_point_mon_list Enable row movement;

表已更改。

SQL> Update oss_actv_point_mon_list
  2    Set monthno = 201105
  3   Where monthno=201102;

已更新522行。

SQL> commit;

提交完成。

SQL> spool off;