SQL> alter table p_objects
2 add partition p201410
3 values less than (to_date('2014/11/01','yyyy/mm/dd'))
4 (
5 subpartition p201410_spdts values ('DTS')
6 , subpartition p201410_spfoo values ('FOO')
7 , subpartition p201410_spbar values ('BAR')
8 , subpartition p201410_spsys values ('SYS')
9 , subpartition p201410_spsysaux values ('SYSAUX')
10 )
11 tablespace tbs1
12 ;
tablespace tbs1
*
ERROR at line 11:
ORA-14048: a partition maintenance operation may not be combined with other
operations
The error doesn't quite make it easy to determine what the problem is. Turns out that the tablespace/storage clause of the ALTER TABLE ... ADD PARTITION has to come prior to the subpartitions definition. Simply moving that part of the statement a few rows up yields success:
SQL> alter table p_objects
2 add partition p201410
3 values less than (to_date('2014/11/01','yyyy/mm/dd'))
4 tablespace tbs1
5 (
6 subpartition p201410_spdts values ('DTS')
7 , subpartition p201410_spfoo values ('FOO')
8 , subpartition p201410_spbar values ('BAR')
9 , subpartition p201410_spsys values ('SYS')
10 , subpartition p201410_spsysaux values ('SYSAUX')
11 )
12 ;
Table altered.
Again, probably obvious to most of you. It wasn't as obvious to decipher when I was trying to add a partition with over 6,300 subpartitions. As always:
