Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 31 Mar 2009 @ 08:42:49 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Restoring cluster backups to smaller system
From:   Young, Mark

Thanks to all who replied, we have successfully followed the path of creating 10 separate tables and then merging them into one. One step that was not self evident initially was using the dictionary restore 10 times in copy dictionary statements to create the 10 tables on the destination system. Once we got this it was very easy to restore each of the cluster archives to an individual table in parallel.

Just to let you know, the archive takes around 40 minutes and the restore takes around 90 minutes with around 70 minutes for the merge, using insert select.


Mark Young
Data Warehouse Technical Specialist

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016