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