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.