If I have to migrate that kind of data it takes couple of days. I cant ask for those many days of downtime.You realize you would have to "migrate that kind of data" anyway, right? It's not magic. Even if you add subpartitions, don't you want to move the existing rows into them?
user8351471 wrote:I've written a short note to give you some idea. As AliD says, you need to look at the options for exchanging partitions and changing partition table defaults.
I have a table abc(c_date date,
The table is already range partitoned on "c_date" column and I have lot of data in that table.
Now my task is to create the hash partions under range; hash partiton needs 16 partitons.
I dont want to create another table with range and hash partitons and migrate the data. The amount of data I have is 3 terabytes.