ORA-39298: Cannot alter materialized view partitioning type or partitioning

曾春华

ORA-39298: Cannot alter materialized viewpartitioning type or partitioning

columns.

Cause: DBMS_METADATA_DIFF wascomparing two materialized views with

incompatible partitioning: (1) one is partitioned and oneis not (2) both are

partitioned but in different ways (locally vs. globally,hash vs. range) (3) both are

partitioned but on different columns. There is no SQLALTER statement to change

the way a materialized view is partitioned.

Action: The difference cannot beeliminated with an SQL ALTER statement.