From JTESTA@longaberger.com Mon, 24 Sep 2001 07:11:57 -0700 From: "JOE TESTA" Date: Mon, 24 Sep 2001 07:11:57 -0700 Subject: Re: partition Message-ID: MIME-Version: 1.0 Content-Type: text/plain by default you can't change the rows part key.    do a alter table enable row movement;   then the row can move between partitions.   joe >>> maya.kenner@trema.com 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