Oracle Error Message
ORA-14259: table is not partitioned by Hash method
Reason for the Error
ALTER TABLE COALESCE PARTITION is only valid for table partitioned by Hash method
Solution
Specify valid ALTER TABLE option for the table, or ensure that the table is partitioned by Hash method