Oracle Error ORA-28654: table and partition not overflow compatible

Oracle Error Message

ORA-28654: table and partition not overflow compatible

Reason for the Error

If one of the tables (partitioned/non-partitioned) has overflow data segment and the other one doesn’t.

Solution

Ensure that non-partitioned and partitioned tables both have overflow data segment or neither one does.