Cause: ALTER TABLE COALESCE PARTITION|SUBPARTITION may be followed by an optional <parallel clause>. No partition/subpartition attributes may be specified See the solution below.
Error solution: Ensure that no partition/subpartition attribute was specified.
Database version: Oracle 11g Release 2 (11.2)