Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2008 @ 21:04:40 GMT

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

<-- Anonymously Posted: Date: Thu, 3 Apr 2008 13:34 -->

     COPY DATA TABLES (DEV_TB) (FROM(PROD_TB)), RELEASE LOCK,
     FILE=myTapeFile;

For tables, it's simple enough. Note, though, that not all object types get migrated as you might hope. For example, dictionary entries for join indexes and stored procedures are copied but those objects will need to be recreated before they can actually be used, and the text of views and macros is copied unchanged (i.e. they still "point" to PROD_TB).

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