Re: Alter Table on 41 million rows (2G):

Posted in 1998

reyes01@ibm.net — 28 Jan 98 21:53:42 GMT — source: Informix-list mailing list archive (1991-1998)

In "Art S. Kagel" <kagel@bloomberg.com> writes: >sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: >BTW you know that each DBSPACE will need AT LEAST as much free space as >it currently uses for the reorg since this is accomplished by creating a new >identical table with the new column type and copying data from the old table What would be the options if one didn't have enough space? Using the HPL to dump the data to tape and then read it back with the HPL again?

Related threads

Using a "+" character in an SQL insert statement?
Re: Delay in commands returning