ORA-12036: updatable materialized view log is not empty, refresh materialized view

ORA-12036: updatable materialized view log is not empty, refresh materialized view
Cause: The updatable materialized view log was not empty. The updatable materialized view log must be empty before an updatable rowid materialized view can be altered to a primary key materialized view.
Action: Ensure that updatable materialized view log is empty by refreshing the materialized view before converting the updatable ROWID materialized view to a primary key materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12036：可更新物化视图日志不为空，刷新物化视图,
.原因：可更新物化视图日志不为空。可更新物化视图日志必须为空，才能将可更新的rowid物化视图更改为主键物化视图。,
.操作：通过在将可更新ROWID物化视图转换为主键物化视图之前刷新物化视图，确保可更新物化视图日志为空。,
.

aiaiDBA

13718043309

010-86462881

ORA-12036: updatable materialized view log is not empty, refresh materialized view

1 个回答

相似问题