Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Feb 2009 @ 22:21:42 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Modify Partition on Column
 
From:   Srinivasa Madagani

Hi,

I am trying to modify my Partition on one of my table as below . I am getting an error. Can you pls correct me if I am missing some thing here in terms of syntax.

     ALTER TABLE EADWCore.PHYSICAL_READING
     MODIFY PRIMARY INDEX Physical_Reading_Np ( METER_SK )
     DROP PARTITION BY RANGE_N(READING_DT  BETWEEN DATE '2003-01-01' AND DATE
     '2006-12-31' EACH INTERVAL '1' YEAR ,
     DATE '2007-01-01' AND DATE '2007-12-31' EACH INTERVAL '1' MONTH ,
     DATE '2008-01-01' AND DATE '2008-12-31' EACH INTERVAL '1' DAY ,
     DATE '2009-01-01' AND DATE '2010-12-31' EACH INTERVAL '1' YEAR , NO RANGE)
     ADD PARTITION BY RANGE_N(READING_DT  BETWEEN DATE '2003-01-01' AND DATE
     '2006-12-31' EACH INTERVAL '1' YEAR ,
     DATE '2007-01-01' AND DATE '2008-12-31' EACH INTERVAL '1' MONTH ,
     DATE '2009-01-01' AND DATE '2009-12-31' EACH INTERVAL '1' DAY ,
     DATE '2010-01-01' AND DATE '2010-12-31' EACH INTERVAL '1' MONTH ,
       NO RANGE);

Thanks in advance for your responce.


Regards,

Srini



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016