Wednesday, February 8, 2017

COPY Script in Teradata

===================================
From dump file to target user copying  the data
===================================

 .LOGON 10.65.43.62/dbc,dbc;

COPY data tables (pdo96src) ( from (pdo95src)),
RELEASE LOCK,
FILE=PDO95SRC;
LOGOFF;


Dump file is PDO95SRC
Source user  : pdo95src
Target user pdo96src
Ipaddress is target machine server ip address


============================
Command
===========================


C:\version12\zs96src> arcmain < pdo96src_restore.txt > pdeo96src_restore.log

No comments:

Post a Comment