Hello,
I have a partitioned
table by range on a column like STATUS , where STATUS can be either say YES or
NO .
i do my
partitionning on this STATUS column.
When i do insert in
this table, data are correctly inserted in the right partition BUT if I want to
update the STATUS field, it returns me an error I found
ambiguous:
"ORA-14402: updating
partition key column would cause a partition change"
The "would" is
confusing , does this mean it won't do it anyhow or with some special keyword
would move it to the other partition.
Thanks,
Maya
