RE: partition

Alter
table XXXX enable row movement;
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Regards
<FONT face=Arial color=#0000ff
size=2>Ivo
 

<FONT face=Tahoma

  size=2>-----Original Message-----From: Maya Kenner   [mailto:maya.kenner_at_trema.com]Sent: Monday, September 24, 2001   04:50 PMTo: Multiple recipients of list ORACLE-LSubject:   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 - 09:39:46 CDT