Cause: A subpartition maintenance operation such as ALTER TABLE MODIFY PARTITION COALESCE SUBPARTITION can only be performed on Hash subpartitioned objects See the solution below.
Error solution: Re-issue the command against a Hash subpartitioned object.
Database version: Oracle 11g Release 2 (11.2)