How to fix the Oracle error ORA-28654: table and partition not overflow compatible?

In this post, you’ll learn more about the Oracle ErrorORA-28654: table and partition not overflow compatible with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28654: table and partition not overflow compatible

Reason for the Error ORA-28654: table and partition not overflow compatible

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

How to fix the Error ORA-28654: table and partition not overflow compatible ?

You can fix this error in Oracle by following the below steps

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