Re-partitioning a table using different field
Hi,
We have a table TRAN_DATA_HISTORY with range partition on 'tran_date' we want to re-partition this table using a different field 'post_date'. Is there an easier way to do it without converting the partitioned table to a non-partitioned table, and then doing the partition on post date.
I tried to use exchange partition but it only works on converting a non-partitioned table to partitioned.
Also, if there is no other way than partitioned -> non-partitioned -> partitioned, how can I un-partition a partitioned table?
Thanks.