Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2014 @ 15:46:17 GMT

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

Hi,

You can do this by copying ONLY DICTIONARY DATA i.e (COPY DICTIONARY TABLES).

If you are using TARA, then you have an option "DICTIONARY BACKUP ONLY" or the sample arcmain script is below:

     .LOGON.......
     ARCHIVE DICTIONARY TABLES
     ("DBA_DATA") ALL,
     RELEASE LOCK,
     FILE=ARCHIVE,
     LOGOFF.

This takes backup of all the database under DBA_DATA and all the objects inside each database.

During Restore, use COPY data tables, to copy the same.

But, note that, the database space for restore(during copying to other system) is taken as per the space in the database which has during backup (initial system).

Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant

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