Archives of the TeradataForum

Message Posted: Wed, 30 Jul 2003 @ 07:34:02 GMT

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

MIke,

Easiest is a single Insert/Select. Only downside to this is the amount of free disk space required, you'll need at least 260GB free for the spool file.

If that's not feasible I'd still go for Insert/Selects but you'll need to run multiple ones, each with a WHERE clause that selects different rows from the source table. You'll then get transient journalling on everything but the first Insert. One thought, make the first Insert/Select as big as your system can handle.

Whichever of these methods you use I'd suggest that your target table has no additional indexes defined on it, add them after you've copied all the data across.

If you can't go for the Insert/Select route then you're probably going to have to Export and Fastload. Again, try for the single suite of jobs if possible but this approach can be executed using multiple Export/Fastload jobs.

Cheers,

Dave

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