Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2010 @ 14:55:08 GMT

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

Hello:

How do you ADD RANGES on multi-level PPI? (See error below)

     ALTER TABLE WORK_DB.tablename
     MODIFY PRIMARY INDEX
     ADD RANGE#L1 BETWEEN DATE '2011-01-01' AND DATE '2012-12-31' EACH INTERVAL
     '1' MONTH ,ADD RANGE#L2 BETWEEN DATE '2011-01-01' AND DATE '2012-12-31' EACH
     INTERVAL '1' MONTH
     ;

     -- FAILED WITH "3732: The facility of altering the partitioning of a
     non-empty table in this case has not been implemented yet. "

Regards,

Mark Jahnke
Morgan Stanley Smith Barney
Teradata DBE / COE

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