partition existing table

[diwakar]

Dear Sir,

Can anyone tell me as to whether if it is possible to partition
an existing table(that has no partition in it) in a database and if so the syntax for the same.....

Thanks and Regards,

K.Diwakar

[rotem_fo]

Hi,
How to Partition an non-partitioned table?
SQL:
1. Create table dummy_t as select with the required partitions
2. Alter table EXCHANGE partition T with dummy_T
3. Drop table T

exp/imp:
Perform the following steps to partition an non-partitioned table:
1.Export the table to save the data.
2.Drop the table from the database.
3.Create the table again with partitions.
4.Import the table data.