Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Confused By Block
 
From:   Jason.Fortenberry

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023