Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-14285 – cannot COALESCE the only partition of this hash partitioned table or index

Oracle Database Error Code ORA-14285 Description :

cannot COALESCE the only partition of this hash partitioned table or index

Error Cause:

A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegal

How to Solve :

Ensure that there is at least one partition. Drop the table or index to remove all partitions.