Hi,

As far as I know you can't partition a table that already contains data. Create another temporary table with the partitons you require from the original. Then delete the original and rename the temporary...

eg :

create table newtable partition by range(column1)
(partition p1 values less than (50),
partition p2 values less than (maxvalue))
as (select from original table);

ensure newtable has been created correctly......
if so then drop original table and rename the newtable to the original tablename.

You may need to recreate any constraints etc...

Cheers

Moff.