Was this helpful?
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.
Last modified date: 06/08/2023