对一个分区表,分区字段为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;
阅读(4781) | 评论(0) | 转发(0) |