Re: copying from unpartitioned to partitioned table

[Mattias Jonsson]

Are you sure you want to partition on phone number and cast it to integer?

1) cast a phone number to integer depends on the format of the phone number string (plus, dash, space characters may interfere with the cast...) and if you are sure this is what you want, then you should first normalize the strings to a format that can be converted to integer (note that an integer does not have leading zeroes.)

2) What queries do you intend to run on the table? if you do exact match (like 'select * from t where phonenum = '0800-...') then you can use KEY partitioning directly with varchar column.

So how do you use the table? (after answering that question it is easier to tell you how to partition your data...)
and what are you trying to accomplish by partitioning the data?