Re2: Alter table.

> Shyam Davuburu (shyam@minerva.robadome.com) wrote: > : 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. > : Thanks in advace > : Shyam > Consider doing an UNLOAD of the table, DROPping the table, ADD new table > with the new column(s), finally doing a LOAD and INSERTing into specific > columns. Don't forget to compensate for the new columns in your LOAD (i.e., add the appropriate delimiters in your ascii file.) > Why? In my experience, the ascii file created by UNLOAD takes a lot less > space than the actual table, DROP will free up space. By the way, you > might also consider doing the UNLOAD into a different file system. I do > this a lot when I start having space problems. ############################################################## David Nguyen Internet: davidn@geis.geis.com GE Information Services UUCP: uunet!ge!davidn 401 North Washington Street Voice: 1-301-340-5461 Rockville, MD 20850 USA ##############################################################