ORA-14402: updating partition key column would cause a partition change

由上一个分区表的问题，引出了另外一个问题ORA-14402
在update更新分区表的分区键的值的时候，需要开启row movement功能，否则会报错
SQL> update par_goolen set created=sysdate where created < sysdate -365;
update par_goolen set created=sysdate where created < sysdate -365
       *
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change

SQL> alter table par_goolen enable row movement;

Table altered.

SQL> update par_goolen set created=sysdate where created < sysdate -365;

49954 rows updated.

SQL> alter table par_goolen disable row movement;

Table altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23249684/viewspace-1389429/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23249684/viewspace-1389429/