对一个分区表,分区字段为date类型的,更新这个字段内容时 提示:

ora-14402,看看帮助怎么说:
oerr ora 14402
14402, 00000, "updating partition key column would cause a partition change"
// *Cause: An UPDATE statement attempted to change the value of a partition
// key column causing migration of the row to another partition
// *Action: Do not attempt to update a partition key column or make sure that
// the new partition key is within the range containing the old
// partition key.
解决方法:
alter table t1 enable row movement;
阅读(4983) | 评论(0) | 转发(0) |