|
|
|
Re: Droping subpartitions of a partition [message #264978 is a reply to message #264923] |
Wed, 05 September 2007 03:14   |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
Someone will correct me if I'm wrong, because I haven't used sub-partitions that much...
The only thing you can do with the sub-partitions of a GIVEN partition is to truncate or exchange them. You can only drop, merge, split or add sub-partitions on EVERY partition at once.
The reason for this - assuming still that my understanding is correct - is that every partition must have the same profile of subpartitions. ie. One partition cannot have 6 sub-partitions whilst another partition has 5 sub-partitions. Droppin, merging, splitting, and adding sub-partitions to a GIVEN partition would violate this rule.
Based of a brief glance at the 11g doco, this rule is unchanged even with all of the additional partitioning features.
Ross Leishman
|
|
|
Re: Droping subpartitions of a partition [message #264998 is a reply to message #264978] |
Wed, 05 September 2007 04:03   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> create table t (c1 integer, c2 integer, c3 integer)
2 partition by range (c1)
3 subpartition by list (c2)
4 ( partition p1 values less than (100)
5 ( subpartition sp11 values (0,1,2),
6 subpartition sp12 values (3,4,5),
7 subpartition sp13 values (default) ),
8 partition p2 values less than (200)
9 ( subpartition sp21 values (0,10,20),
10 subpartition sp22 values (30,40,50),
11 subpartition sp23 values (default) ),
12 partition p3 values less than (maxvalue)
13 )
14 /
Table created.
SQL> alter table t merge subpartitions sp11, sp12 into subpartition sp11;
Table altered.
Regards
Michel
|
|
|
|