Originally posted by gschuah
2. How to reorg a table if it grow too large?
I guess it depends what steps are acceptable to you.

Obviously, you could delete data. I expect that isn't what you meant, though.

If you have a table for which the data is pretty static, meaning it's hardly ever modified, then you could consider compressing it.

If you have been deleting data and the free space is not getting reused, then you may have too low a PCTUSED value, which sets the used-space threshold below which a block can be reused for the insert of new rows.

To do a "one off" removal of the empty space you could use the "move table" command to get he gaps refilled -- "alter table my_table move pctfree 10 pctused 85" would rebuild the table and change pctused at the same time.

If you have columns which are commonly null, then you could place them as the last columns in the table definition.