Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 14:14:02 GMT

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

Subj:   Re: ALTER TABLE Question
From:   Geoffrey Rommel

Phil Oldfield hat geschrieben:

  I want to ADD a char(2) column to a 200Gb table using alter table. This is due to not having enough space to recreate the table. Is there any way of working out approx how long the alter table command will take to execute?  

We avoid "alter table" whenever possible. I would recommend one of these approaches:

- Temporarily steal some space from your spool_reserve to build a new copy of the table with insert/select. (You do have a spool_reserve, I hope!)

- Unload the table to a flat file (MVS or Unix) and then reload it. I haven't done this very much, but it would probably go better if you include your new column when unloading the data. You could do this by defining a one-row table with a char(2) column containing blanks (or other default value) and then doing an unconstrained join to it in your FastExport. Use "format fastload" in the FastExport, drop the existing table, and load with FastLoad.

  <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