Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    9

    Smile Unanswered: Reorganising Huge tables to more data locations .

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Brisbane Australia
    Posts
    6
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •