partition

<SPAN

class=609561113-24092001>Hello,
<SPAN

class=609561113-24092001> 
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.
<SPAN

class=609561113-24092001> 
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"
<SPAN

class=609561113-24092001> 
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.
<SPAN

class=609561113-24092001> 
<SPAN

class=609561113-24092001>Thanks,
<SPAN

class=609561113-24092001>Maya Received on Mon Sep 24 2001 - 08:50:44 CDT