Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: partition

RE: partition

From: Wong, Bing <bing.wong_at_IngramMicro.com>
Date: Mon, 24 Sep 2001 09:30:42 -0700
Message-ID: <F001.003966CB.20010924092907@fatcity.com>

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

 
 
 

<FONT

  face=Tahoma>-----Original Message-----From: JOE TESTA   [mailto:JTESTA_at_longaberger.com]Sent: Monday, September 24, 2001   8:10 AMTo: Multiple recipients of list ORACLE-LSubject:   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
  >>> maya.kenner_at_trema.com 09/24/01 10:50AM   >>>
<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 - 11:30:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US