ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

When table is partitioned and it has subpartitions I received ORA-14287 error when I was trying to move partition to tablespace with nologging storage option:


SQL> ALTER TABLE TABLE_NAME
    MOVE PARTITION PARTITION_NAME
    TABLESPACE TABLESPACE_NAME;
    MOVE PARTITION PARTITION_NAME
                   *
ERROR at line 2:
ORA-14257: cannot move partition other than a Range or Hash partition


It means that it is impossible move logical structure to somewhere. It is better to move subpartition first and modify default attributes for partition next.

alter table TABLE_NAME MODIFY DEFAULT ATTRIBUTES FOR PARTITION PARTITION_NAME TABLESPACE TABLESPACE_NAME;