Restoring of file.

UDA
N/A

Restoring of file.

hi all ,
i am a new user of Teradata .
i have a archive file with name "file" , i want to restore it in my database "DP_Stg".
can some please help me and guide me the way to upload / restore this file in my database .
1 REPLY

Re: Restoring of file.

This is a general syntax.

from acrmain utility ..

.logon tdpid/user,pass;

COPY DATA TABLES (DP_Stg) (FROM (originaldb))
,ABORT, RELEASE LOCK, FILE = file;

LOGOFF;

.QUIT;

where originaldb is the name of the database that was actually archived to the "file".

The Archive and Recovery manual will give you more options that can be used with COPY command