Archives of the TeradataForum
Message 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|