Reduce the number of Subpartitions

From: Marcus <marcus_chn_at_yahoo.com>
Date: 1 Feb 2005 02:51:02 -0800
Message-ID: <a9eeace0.0502010251.60e9138f@posting.google.com>

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 Received on Tue Feb 01 2005 - 04:51:02 CST