Archives of the TeradataForum

Message Posted: Thu, 30 Aug 2012 @ 10:59:27 GMT

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

Roopalini,

If you ave backed it up using DUMP file in unix or windows location then use below script. If in tapes/Disc then the filename will depends on your backup configuration and script needs some changes.

     LOGON TPID/USERNAME, password;
     COPY DATA TABLES
     ( DB.TB ) ??? (from (? DB.TB ) ),
     RELEASE LOCK,
     FILE=DUMPNAME;
     LOGOFF;

Thanks

Machha

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