Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 02 Aug 2012 @ 21:02:53 GMT


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


Subj:   Re: Using Partition backup for multiple specific
 
From:   Barner, Eric

Thanks!

Actually found the solution today in a Knowledge Article.

Here is an excerpt from the KA.

In order to back up more than one partition, you need to make sure that your where clause exists between the opening and closing '!' symbol shown in the syntax example below.

          ARCHIVE DATA TABLES
          ( prod_edw_tb.CELR_ACT_INCNTV_LINE)
          (PARTITIONS WHERE
          (!(RPTD_AS_DT BETWEEN '2008-03-15' AND '2008-04-15')
          OR
          (RPTD_AS_DT BETWEEN '2007-03-15' AND 2007-04-15')!))


     
  <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: 28 Jun 2020