Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2010 @ 15:25:45 GMT

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

Mark Jahnke wrote:

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

You can only add to the top-most range, RANGE#L1, for sub-ranges you have to drop the same number of partitions you're trying to add, i.e. the number of partitions per sub-range must not change.

Dieter

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