Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Can't drop a range of rows

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023