RE: partition

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Mon, 24 Sep 2001 07:43:16 -0700
Message-ID: <F001.003962B8.20010924072034@fatcity.com>

In
8.0.x it will NOT do the update. I think in 8i it will but not sure.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Rick

<FONT face=Tahoma

  size=2>-----Original Message-----From: Maya Kenner   [mailto:maya.kenner_at_trema.com]Sent: Monday, September 24, 2001   10:50 AMTo: 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:43:16 CDT