Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-39298

Cannot alter materialized view partitioning type or partitioning columns.

Cause

DBMS_METADATA_DIFF was comparing two materialized views with incompatible partitioning: (1) one is partitioned and one is 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 SQL ALTER statement to change the way a materialized view is partitioned.


Action

The difference cannot be eliminated with an SQL ALTER statement.