Archives of the TeradataForum

Message Posted: Mon, 26 Nov 2001 @ 15:49:03 GMT

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

Hi,

one option that works with all versions is

- create a new table with the structure of the original table. NUPI to avoid duplicates does make sense in my opinion.

- do an insert-select in access mode.

If you have a newer version of Teradata you can use the command "release mload... in apply;"

But always be aware of inconsitencies that may occurr due to a "bad" mload.

Ralf

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