DROP TABLE EX235;SEGMENT SHRINKWHEN A ROW IS DELETED, THE SPACE IT WAS OCCUPYING IN ITS BLOCK BECOMES AVAILABLE FOR REUSE WHEN ANOTHER ROW IS INSERTED

9. Tidy up:

Segment Shrink

When a row is deleted, the space it was occupying in its block becomes available for

reuse when another row is inserted. However, the nature of the activity against a table

can result in a significant amount of wasted space within a table. This could be

reclaimed with a MOVE operation: following a MOVE, all the blocks will be consecutively

full of freshly reinserted rows. But during the MOVE, the table is locked and following

it all the indexes must be rebuilt. For many environments, this makes use of MOVE to

reorganize tables impossible. The SHRINK command, while not as effective as a MOVE,