Skip to Content
0
Apr 30, 2014 at 01:53 PM

Change partition type and 2 billion rows limit.

138 Views

Hello experts ,

My DB's 1 table has 4 billion records , so I'm using range partition for this , I devided 10 partitions.

I want to change this range partition to hash partition.

In this time , I think I should do following .

1. execute "alter table bigtable merge partitions";

2. execute "alter table bigtable partition by hash (column1) partitons 10"

I think it will be correspond to 2 billion row limit in sequence 1.

How to execute re-partitioning in this case ? Should I unload current data to file or sometiong and load from this

Regards,

Jim