Modify...to Reorganize Option
To move the data and change the number of locations without changing storage structure, specify reorganize. For example, to spread an employee table over three locations:
modify employee to reorganize
with location = (area1, area2, area3);
When you specify reorganize, the only valid with clause option is location.