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