How to partition Non-partitioned table?

[samirshah]

Hi friends,

How do I partition existing Non-partitioned table.

I checked ALTER TABLE syntax. I did not find anything to convert Non-partitioned table into partitioned one.

Any idea?

Thanks in advance

Sam

[marist89]

1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions

[mpbmw]

1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions

------------------------------------
My existing table has a lot many database triggers onto the unpartitiond table. Its is the center(child) table of FINANCE system, with lots of header tables onto it.

In this senerio how to workaround?

[marist89]

Originally posted by marist89
1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions