Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2010 @ 16:43:59 GMT

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

Cool and sweet answer from Dieter...Loads of Thanks for the tip.

It Worked:

     ALTER TABLE WORK_DB.tcash_activity_delta_092910
     MODIFY PRIMARY INDEX
     DROP RANGE#L2 BETWEEN  DATE '2002-08-01'  AND DATE '2004-07-31' EACH
     INTERVAL '1' MONTH ADD RANGE#L2 BETWEEN DATE '2011-01-01' AND DATE
     '2012-12-31' EACH INTERVAL '1' MONTH ;

It means, we need to drop earlier 2 years to be able to accommodate new 2 years partitions. That solves the riddle.

Regards,

Mark Jahnke
Morgan Stanley Smith Barney
Teradata DBE / COE

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