Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Oct 2002 @ 15:42:02 GMT


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


Subj:   Re: Archive & Restore from one Teradata environment 2other.
 
From:   Michael Riegelman

Ganesh,

Try the code below. The problem you are having is because the database id is not on the second system. Use the COPY command in place of the RESTORE.

logon tcrm/user1,pal;
COPY DATA TABLES (iastest2),
RELEASE LOCK,
FILE=textias;
LOGOFF;



     
  <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