Dumping and reloading the database creates a new starting version of the database and loads the table contents into this new database. During the loading stage, any gaps created when database elements were deleted are removed, thereby more efficiently allocating disk space. There are many methods available to dump and load data; for instructions, see Dumping andLoading.

You can use PROUTIL TABLEMOVE and PROUTIL IDXMOVE to move tables and indexes from one storage area to another while the database remains online. As a result, disk space is efficiently allocated and gaps are removed. For more information about moving tables and indexes, see MaintainingDatabase Structure.