Dear all,

I have an old and non-partitioned table with couple hundred millions of rows. Now we need to partition the table to increase performance. Is there a way that I can add partition to the table without recreating it? I tried this and got error:

alter table test add partition by range (DATE)
(partition DEC04 values less than ('01-JAN-05'),
partition JUN05 values less than ('01-JUL-05'));

alter table test add partition by range (DATE)
*
ERROR at line 1:
ORA-00902: invalid datatype

I know that Oracle will allow me to add partitions to existing partitioned table, but what about a non-partitioned table?

Any help will be appreciated.


Thanks,
Unna