|
Archives of the TeradataForumMessage Posted: Fri, 07 Dec 2012 @ 19:43:58 GMT
I am trying to drop some rows between these ranges but can't with an error, "DROP RANGE specifies non-existing ranges or partitions." I don't know why I can't drop them. -- This one doesn't work. The alter stmt-- alter table TEST01 modify primary index drop range between DATE '2010-01-01' and DATE '2010-12-31' EACH INTERVAL '7' DAY; --This one works-- alter table sys_hist.jptest modify primary index add range between DATE '2013-01-01' and DATE '2013-12-31' EACH INTERVAL '7' DAY; --A part of the table definition-- PRIMARY INDEX XXXX ( LogDate ,QueryID ) PARTITION BY RANGE_N(LogDate BETWEEN DATE '2009-04-27' AND DATE '2012-12-31' EACH INTERVAL '7' DAY ); Thank you in advance James Park
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||