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 Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008