RE: partition

[Cale, Rick T (Richard)]

In 8.0.x it will NOT do the update. I think in 8i it will but not sure.

 

Rick

-----Original Message-----
From: Maya Kenner [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
Subject: partition

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