Archives of the TeradataForum

Message Posted: Fri, 11 Nov 2005 @ 19:48:42 GMT

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

Dave,

Try the command below:

     alter table XXXX modify primary index
        add range between 200601 and 200652 each 1

This would expand your partitions for one more year. You may adjust the range according to your needs.

I hope this helps!

Fabio

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