PDA

View Full Version : Reorganising Huge tables to more data locations .

rob@tyketto
08-21-02, 06:16
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
jahowell
08-21-02, 21:17
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.