ORA-39300: Cannot alter materialized view log partitioning type or partitioning columns. ORACLE 报错 故

文档解释

ORA-39300: Cannot alter materialized view log partitioning type or partitioning columns.

Cause: DBMS_METADATA_DIFF was comparing two materialized view logs 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 log is partitioned.

Action: The difference cannot be eliminated with an SQL ALTER statement.

官方解释

在出现这种情况时，要想解决该问题，需要使用如下一系列步骤来改变分区类型或者分区列：

1.首先用dbms_mview.refresh_mview_log 给物化视图日志或在启用多版本读取时使用 dbms_mview.refresh_all_mview_log 进行刷新；

2.接着，删除原物化视图日志；

3.然后，改变物化视图日志的分区类型或者分区列；

4.最后，创建一个日志表，将上述物化视图添加到该日志表中；

这样就可以解决这一问题。