UDA
Fan

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".
Enthusiast

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