Oracle Error ORA-14259: table is not partitioned by Hash method

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