Hi,

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

As the table size is huge, I prefer option 1.

Thanks in advance.

Thanks,