Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Unanswered: Reorg space required

    Hi,

    Can anyone refresh my memory? What is the least amount of space a table must have required to do a table reorg? Is it double the allocated size of the table? Or, is it double the used size?

    Example -

    Table A is allocated in a tablespace 2 gig. Its used pages equals about a half a gig. To run a reorg on this table, does the tablespace need at least 4 gig, or, 1 gig? This is being that you at least need double the size of the table to do a reorg.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42
    I found the answer this after I posted this - You need to make sure you have enough space in the tablespace for another copy of the table. This is in order for the reorg utility to make a ghost copy of the table in the same tablespace during the reorg process.

Posting Permissions

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