Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Oct 2002 @ 14:54:33 GMT

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

Subj:   Re: Archive & Restore from one Teradata environment 2other.
From:   Dodgson, Mark


You can only RESTORE data to a target system, when the DD/D (in database DBC) between the two systems match. So, unless you can restore DBC and dictionary from source to target system (to do this, you'll need to clear the target system down to sysinit state, so I doubt it), you'll have to use COPY to perform the data load.

Bear in mind that when you COPY a database from source to target, this will result in different database ID's being created on the target system. DBC uses these ID's (amongst other things) to reference access rights. As the source system dictionary references are effectively being ignored in a COPY operation, an entry will be created in DBC.Association to link the old database/table name to the new. This link allows you to subsequently roll-forward journals (for example) to the new tablename, even when the journal archive (taken from source system) relates to the old database/table.


COPY DATA TABLES (iastest2),

This will create iastest2 on the target system - if you want to change the name of the target table, then use the FROM clause, e.g.

COPY DATA TABLES (iastest2-new),
(FROM (iastest2)),

Hope this helps,


  <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