Oracle Error ORA-39279: Cannot alter tablespace of overflow segment.

Oracle Error Message

ORA-39279: Cannot alter tablespace of overflow segment.

Reason for the Error

DBMS_METADATA_DIFF was comparing two index organized tables whose overflow segments have different tablespaces. There is no SQL ALTER statement to change an overflow segment’s tablespace.

Solution

The difference cannot be eliminated with an SQL ALTER statement.