As we saw in previous posts by just defining number of partitions we can create partitions in HASH partition or *-hash subpartitions paritioning type. Now to remove some partition we can use coalesce partition feature of oracle. After we apply coalescing function one hash partition is removed and data are redistributed among the partitions which […]