Re: partition

[JOE TESTA]

by default you can't change the rows part key.    do a alter table <table_name> enable row movement;   then the row can move between partitions.   joe >>> [EMAIL PROTECTED] 09/24/01 10:50AM >>> 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