Archives of the TeradataForum
Message Posted: Tue, 31 Mar 2009 @ 08:42:49 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|