Oracle Error ORA-39281: Cannot alter COMPRESS in index-organized materialized view.

Oracle Error Message

ORA-39281: Cannot alter COMPRESS in index-organized materialized view.

Reason for the Error

DBMS_METADATA_DIFF was comparing two index organized materialized views with different key compression values. There is no SQL ALTER statement to modify the key compression of an index organized materialized view.

Solution

The difference cannot be eliminated with an SQL ALTER statement.