Re-Partition default table partition data

As a developer, I want to ensure that partitions are maintained properly to handle errors in data processing.

Whenever data are inserted into a partitioned table and the partition key does not match any attached partition, the default partition is used. This is to ensure that no data are lost. However this can pose a problem if a partition is created with a range that overlaps data existing in the default partition.

A process should be created that can re-partition data from the default partition into new table partitions effectively and safely with minimal iops and minimal locking.

Acceptance

• Functionality to re-partition default partition data into month partitions.
• Ability to run this functionality at the table, schema, or database scope.