Re: Alter table.

> > Hi, > Is there anyway i can add a new column to a table without the temporary table > being created? The problem i have is that i don't have enough dbspace left, but the table has millions of rows, how can i add a new column to the table without running out of dbspace? If anybody has any ideas please let me know. > Perhaps you could unload to disk, remove the old table, recreate with a new schema, then load it with dbload, specifying the columns you want loaded. -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona Everything should be made as simple | as possible, but not simpler --Einstein | Visualize Whirled Peas