Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 14:14:02 GMT
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.
|