Hi,
I am wanting to split 8gb file into 10 locations (currently split over 5 locations - 4k page size) to prevent the 2gb file limit being hit, does Ingres require a reasonable amount of work space to do this, or is the space needed for sorting/calculation actually required in the data partitions themselves ?

I have 2Gb available in work area.

Thanks
Rob

It should require the same amount of space as a modify statement. If you can re-modify a table, you should be able to re-locate it.