Hrishy, There was another discussion on this topic recently on this list, you may want to review the recent messages. Since nobody has responded to your request yet, I'll offer a couple of suggestions. - Refresh your test or development database from production (using a clone procedure, not exp/imp), then a test reorganization, measuring the resulting size. - Do a Google search on "oracle table space estimate". Eventually you'll find some papers that describe methods for performing estimates. Ensure you have reasonably fresh statistics on this table, then take AVG_ROW_LEN and calculate how many rows will fit into a block, given the block overhead (this is the tough part), and your PCT_FREE setting. This is not exact, but can give you a fairly close estimate. Dennis Williams