Archives of the TeradataForum

Message Posted: Sat, 17 Nov 2002 @ 00:18:40 GMT

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

Dave,

You have not provided much detail here. But, if the two tables are on the same system then you should first consider performing an insert/select (insert into target select ... from source). This is very efficient especially if the primary indexes are identical. If they are not, and the source table is relatively large then you will redistribute the source table to the target table and stand the chance of exceeding your spool space limitation.

If you really need to export the table first and Fastload the exported file the utilities manuals contains some useful examples.

Regards,

Doug Drake

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