Migrating Normal Table to Partition Table

[mike9]

Another way would be to:

1) Create the table partitioned as you want
2) Insert as select from your source table
3) Drop your source table
4) Rename your new table to the desired table name (ALTER TABLE new_table RENAME TO source_table)

HTH
Mike