Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 19:43:45 GMT

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

<-- Anonymously Posted: Thursday, November 10, 2005 13:27 -->

ALTER TABLE db.tbl MODIFY PRIMARY INDEX ADD RANGE BETWEEN start AND end EACH size;

- If you also need to remove 'old' partitions when you cycle your table partitions forward (e.g. if you are holding data which is no longer required), there is also a 'DROP RANGE' command. (NCR recommend you remove old partitions if data is no longer required)

But do be careful here... Drop Range takes an exclusive lock on your table (as does Add Range) and may be problematic if the range you wish to drop contains data.. (Depending on the nature of your table design, types of indexes etc. such a Drop may take a long time, causing blocking issues).

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