Archives of the TeradataForum

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

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

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>>