Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2014 @ 15:42:50 GMT

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

Yes. It's very possible. Use the DICTIONARY backup/restore in lieu of DATA backup/restore Chapter 6 of the archive/recovery manual.

On the source system (cascade through DBC hierarchy to capture all object definitions, stats, etc.):

     ARCHIVE DICTIONARY TABLES (DBC) ALL,
        EXCLUDE (DBC),
        RELEASE LOCK,
        FILE=XXXX;

On the Target system:

     COPY DICTIONARY TABLES ALL FROM ARCHIVE
        RELEASE LOCK,
        FILE=XXXX;

Kyle Prescott
DBA Manager
Unum-GHDS
Chattanooga, TN

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