Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Can't drop a range of rows
 
From:   JAMES PARK

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