Re: Alter table.

Shyam Davuburu (shyam@minerva.robadome.com) wrote: : 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. If you can't use alter, you will need to unload the table, drop it, create it with the new column, then use dbload to repopulate. --- jim young jimw@sunnet.chotel.com database janitor choice hotels international, inc. -- --- jim young jimw@sunnet.chotel.com database janitor Voice: 602 953 4421