Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 21 May 2012 @ 19:12:34 GMT


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


Subj:   Re: How to copy database tables
 
From:   Bodla, Sravan Kumar

Hi,

You can try like this...

Backup:

     LOGON /user, password; ARCHIVE DATA TABLES (DBC.abc_xyz),
     (DBC.pqr_fgh), (DBC.ghi_pst), RELEASE LOCK, FILE=dbc_bkp; LOGOFF;

If SSH is enabled between the two servers... then

Go to the above dbc_bkp dump location and perform the restore...

     LOGON /user, password;
     copy DATA TABLES
     (DBA_WORK.abc_xyz ) ( from  ( DBC.abc_xyz)), (DBA_WORK.pqr_fgh ) ( from  ( DBC.pqr_fgh)),
     (DBA_WORK.ghi_pst ) ( from  ( DBC.pqr_fgh )), RELEASE LOCK, FILE=dbc_bkp; LOGOFF;

The user should have dump, restore rights on DBC and DBA_WORK databases in respective environments.


Thanks,

Sravan.



     
  <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: 23 Jun 2019