RE: partition

[Wong, Bing]

That's right.   But I am curious, why you partitioned it for just 2 values?  How big is the table in terms of number of rows?    Bing       -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: partition 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