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?
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.
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.