Partitioning an unpartitioned table

[kaushik.nandy]

hi,

I have an existing table that is not partitioned .
How do I create partition on the table without dropping the table.
The Table may or may not have constraints like primary key.
Assume that the table is empty.

Is there any way to partition the table using ALTER TABLE ADD PARTITION ....... syntax ??
I have using oracle 11g.

[Tim...]

Hi.

You have a couple of options:

http://www.oracle-base.com/articles/mis ... tition.php
http://www.oracle-base.com/articles/mis ... -table.php

Cheers

Tim...