ORA-14402 错误是 Oracle 数据库中的一个常见错误,具体含义为 "updating partition key column would cause a partition change"。这个错误发生在尝试更新一个分区表的分区键列时,如果更新后的值导致行需要移动到另一个分区,而表没有启用行移动(row movement)功能,Oracle 就会抛出此错误。 ORA-14402错误的可能原因...
the rowid changes - it is just like delete + insert --- from tom. I came to this page after getting the "ORA-14402: updating partition key column would cause a partition change" error message. I then tried ALTER TABLE xYz ENABLE ROW MOVEMENT and, like a miracle, my problems fizzled ...
ORA-14402: updating partition key column would cause a partition change 可以通过打开表的row movement属性来允许对分区字段的update操作。 alter table XXXXX enable row movement; 更改分区表的分区键值,意味着要删除记录并重新插入一条新的记录,这会引起记录(Record)的移动,记录的Rowid会改变,相关索引需要进行维护。
Oracle GoldenGate - Version 11.1.1.0.0 and later: Replicat fails with "OCI Error ORA-14402: updating partition key column would cause a partition change"
ORA-14402: updatingpartitionkeycolumnwould cause apartitionchange 解决办法 对该表启用行移动。 演示: SQL>altertablet_order_photo enablerowmovement;Tablealtered.SQL>updatet_order_photo t2sett.edate=sysdate,editor='Alen',photo_status=03wheret.id=611;1rowupdated.SQL>...
I came to this page after getting the "ORA-14402: updating partition key column would cause a partition change" error message. I then tried ALTER TABLE xYz ENABLE ROW MOVEMENT and, like a miracle, my problems fizzled away! I learnt a ...
ORA-14402: updating partition key column would cause a partition change test@CENTRAL> Stefan On 5/2/06, hamid alavi <alavihamid@gmail.com> wrote: List, I have partition table and I did alter table table_name enable rowmovement, then when I try to Disable row movement still when I updat...
ORA-14402: updating partition key column would cause a partition change这个错误的解释是: ORA-14402: 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 ...
ORA-14402 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 ensure that the new partition key...
PARTITIONEDVARCHAR2(3)指示此表是否分区。设置 是 如果是分区。 IOT_TYPEVARCHAR2(12)如果这是一个索引组织表,值为 IOT, IOT_OVERFLOW, 或者 IOT_MAPPING,否则为NULL TEMPORARYVARCHAR2(1)当前会话只能看到它放在这个对象本身中的数据吗? SECONDARYVARCHAR2(1)是否被ODCIIndexCreate 触发创建 ...