Archives of the TeradataForum

Message Posted: Tue, 31 Aug 2004 @ 19:48:57 GMT

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

Bill,

The alter table explain plan says that it first locks DBC.AccessRights for write, and it is not going to release that lock until the alter statement completes. It looks like that is just the way Teradata implements the Alter Table command. I would imagine they have some DBC integrity type reason for doing so. Is the Insert\Select into a new table option not available for your user? I advocate this method over the alter table command as much as possible, assuming you have the available disk space.

Depending on how long it has been running, I think the normal rollback of 3 to 4 times the execution time should be expected.

--Jason

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