Non-partition table to partition

[PAVB]

Could you please share your views to convert non-partitioned table to partitioned which is 600GB size?

Option 1: using data pump
Option 2: pre create partition table and do insert with append hint
Option 3: use dbms_redefinition package

We recently used option #2 for a two billion rows table; we chose #2 because less physical I/O than option #1 and also for allowing more "control" over the whole process.

1- pre create partitioned table -in our case date range per YYYYMM, one tablespace per "year"
2- start multiple insert streams -in our case one job per year so each job would take care of loading twelve YYYYMM partitions using append hint.
3- build indexes -in our case all of them locally partitioned.
4- gather fresh performance stats.

It worked like a charm.