Archives of the TeradataForum

Message Posted: Mon, 15 Apr 2002 @ 14:52:18 GMT

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

If you have the disk space, try creating a temporary new table with the non-updated records and the new updated records (via bteq using the multi-insert syntax to avoid logging inserts into a table with existing records.) Delete all records from original table then insert new records from new temporary table into orignal table. Once validated, you can drop the temporary new table.

Hope this helps,

Claybourne Barrineau

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