Oracle Error ORA-14303: partitions or subpartitions are not in the right order

Oracle Error Message

ORA-14303: partitions or subpartitions are not in the right order

Reason for the Error

User attempted to rebuild a partition of a Composite Range partitioned index which is illegal

Solution

Re-order the partitions or subpartitions in the added LOB storage clause by partition or subpartition DDL order, and retry the statement.