Re: Reduce the number of Subpartitions

Marcus wrote:

> Hello
> Can someone suggest the best method to maintenance for the partitioned
> table in production. Would like to reduce the number of subpartitions
> from 32 to 8 (for P1), without loosing any data
> RDBMS: 9.2.0.4
>
> TableName: DWH_RATED_QUE
> No of Partitions: 8 (P1, P2, P3, P4, P5, P6, P7, P8) using RANGE
> method
> No of subpartions for each partition: (P1 has 32 subpartitions, P2,
> P3, P4, P5,
> P6, P7 and P8 has 8 subpartitions each) using HASH method
>
>
> I am using Composite Partitioning
>
> thanks

Merge subpartitions. Examples can be found at http://tahiti.oracle.com and at http://www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)