Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Mar 2002 @ 13:22:25 GMT

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

Subj:   Re: ALTER TABLE Question
From:   Rudel Simard

I did this method with a table of 75 gig 2 weeks a go. But in your case, you need to have 3 times 200 gig. One for the original table, one for the table in the spool and one for the new table. For the reason of John Hall

If an alter table fails (or is cancelled) when it's adding 1 or more columns.... I choose to duplicated the table instead of ALTER TABLE.

Do some test with insert a smaller table to understand the way Teradata work in this case.

Rudel Simard
Régie de l'assurance-maladie du Québec
DBA de l'environnement informationnel

  <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: 28 Jun 2020