Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Sep 2012 @ 09:42:42 GMT


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


Subj:   Re: Database recovery
 
From:   Dave Wellman

Hi James,

In principle you have the same options in Teradata (and probably in any DBMS) and as usual there are a number of ways of achieving this.

1) Use ARC or FastExport to take your pre-load and post-load copy of the data.

2) Clone the table before the load and then again after the load.

3) Add a "load sequence number" or "load date" column to your table definition and then delete rows using that column if necessary.


There are probably others as well but that's a start.

Which one is best for you will depend on a number of factors, but size of the table is probably the major one.

- Does your Teradata system have enough spare disk space for three copies of the data (option #2)?

- How long does it take to take a copy (option#1)?

- Can you affect the table definition (option#3)?

- If the table is PPI'd and you are loading into new partitions can you copy just the affected partitions?


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 15 Jun 2023