Archive for February, 2013

Create Partition in an Old Table Oracle

You can partition a non-partitioned table three different ways:

A) export/import method
B) Insert with a subquery method
C) Partition exchange method

Either of these 3 methods will create a partitioned table from an existing non-partitioned table.
Continue reading