Archives of the TeradataForum

Message Posted: Wed, 22 Feb 2006 @ 16:38:42 GMT

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

Harshida: The answer to your question is, absolutely not. Only one fastload or multiload is allowed on a table at one time. It locks the table for similar to an exclusive lock, called an MLOAD lock when it starts to build the rows. This lock has one phase that allows users to access the table rows, but the second phase does not. Once the MLOAD lock is established, no other MLOADs are allowed.

I am sure this is not what you wanted to hear. If you need to load more rows, you could always use a staging table and put those rows into the other table after Multiload has finished. You might want to consider Fastload for loading the staging table(s).

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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