Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : ALTER TABLE : Migrating data from existing unpartitioned tables to partitioned tables : Moving the physical data from the composite initial partition to its respective partitions
 
Moving the physical data from the composite initial partition to its respective partitions
After the composite or regular (non-composite) partitions are split into several partitions and marked as split targets, the data residing in the composite initial partition or the source RANGE partition can be moved to the respective partitions using the PROUTIL utility.
After the data is migrated, the process of converting an unpartitioned table to a partitioned table or splitting an existing RANGE partition to one or more partitions is complete.
Note: Running the PROUTIL split utility with the composite initial option moves the data from the partitions that are added and marked as split targets, leaving the remaining data in the composite partition.