Archives of the TeradataForum
Message Posted: Wed, 20 Mar 2002 @ 13:22:25 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|