Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2010 @ 16:21:00 GMT

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

Geoff: The code below should copy from one table to another and will override the target table schema with the source table schema. This is for loading within the same TD server.

     CREATE TABLE
     DB_TARG.TABLE_TARG
     AS
     DB_SRC.TABLE_SRC
     WITH DATA AND STATS;

For TD Server to TD Server, use ARCMAIN, but use ARCHIVE (one table or an entire Database) and COPY (instead of RESTORE). COPY will forgive differences in the two servers' configurations, whereas RESTORE requires identical server configurations.

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