Archives of the TeradataForum

Message Posted: Fri, 07 Dec 2012 @ 19:43:58 GMT

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

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
Database Specialist II

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