Archives of the TeradataForum

Message Posted: Thu, 19 Oct 2006 @ 19:12:40 GMT

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

This means your request was blocked by a query with an exclusive lock on the table because it is restructuring the table. The blocking query is usually an alter table, create index or Create join index which all restructure a table.

You need to find the query that is restructuring the table and schedule your query around that maintenance or eliminate the restructure.

Thanks,

Bob Diehl

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