8. SQL Statements : MODIFY : Modify...to Reorganize
 
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.