Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2010 @ 14:55:08 GMT


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


Subj:   How do you ADD RANGES on multi-level PPI?
 
From:   Jahnke, Mark

Hello:

How do you ADD RANGES on multi-level PPI? (See error below)

     ALTER TABLE WORK_DB.tablename
     MODIFY PRIMARY INDEX
     ADD RANGE#L1 BETWEEN DATE '2011-01-01' AND DATE '2012-12-31' EACH INTERVAL
     '1' MONTH ,ADD RANGE#L2 BETWEEN DATE '2011-01-01' AND DATE '2012-12-31' EACH
     INTERVAL '1' MONTH
     ;

     -- FAILED WITH "3732: The facility of altering the partitioning of a
     non-empty table in this case has not been implemented yet. "

Regards,

Mark Jahnke
Morgan Stanley Smith Barney
Teradata DBE / COE



     
  <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