Oracle Error ORA-39299: Cannot alter materialized view physical organization.

Oracle Error Message

ORA-39299: Cannot alter materialized view physical organization.

Reason for the Error

DBMS_METADATA_DIFF was comparing two materialized views with different physical organizations: heap, index organized, etc. There is no SQL ALTER statement to change the index organization of a materialized view.

Solution

The difference cannot be eliminated with an SQL ALTER statement.