Archives of the TeradataForum

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

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

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>>