Archives of the TeradataForum

Message Posted: Fri, 15 Sep 2006 @ 09:43:24 GMT

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

<-- Anonymously Posted: Thursday, September 14, 2006 16:04 -->

Anomy,

When you create/replace your "dirty read views" make sure that you include 'LOCKING TABLE databasename.tablename FOR ACCESS' in the DDL statement. This should allow you to access the underlying tables while the data is being loaded and prevent any lock contentions.

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