After you prepare partition definitions, you are ready to move existing table data for the partition definitions online from the initial composite partition to the split-target partitions. After the move is completed, the split-target partitions become regular partitions.

Note: Splitting partitions is resource-intensive. You should try to do it when there is a minimal amount of database activity. If the split operation is interrupted or does not complete, you can re-run it; the operation will continue from where it left off.

To move existing data to split-target partitions online, you use the PROUTIL PARTITIONMANAGE SPLIT utility:

proutil db-name -C partitionmanage split table table-name composite initial [useindex index-name] [recs numrecs]

Where:

index-name

The name of a local index to use when scanning the table during the split.

For best performance, use a unique local index, if available.

numrecs

The number of records to move in one transaction. The default value is 100.

Assume that the sportsco database is up and running.

Here is an example of a PROUTIL PARTITIONMANAGE SPLIT command to move existing data online from the initial composite partition of the Order table into its split-target partitions using the CarrierOrderDateLocalIdx index and 200 records per transaction.

proutil sportsco -C partitionmanage split table order composite initial useindex carrierorderdatelocalidx recs 200