Archives of the TeradataForum

Message Posted: Fri, 12 Oct 2007 @ 13:00:27 GMT

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

There are two ways to release a fastload lock:

1. finish the fastload, which means leave your hands off of the error tables and restart "the same" fastload. When it finishes the table lock will be released.

2. drop the empty locked table (because if you can't restart Fastload you most likely dropped the error tables)

Number 1 is normally the wise choice and these are your only choices. Now it is up to you, choose wisely Grasshopper (from old TV show).

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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