ORA-32422: commit SCN-based materialized view log cannot be created on table "string"."string" when there exist direct load/PMOP log entries for the table

ORA-32422: commit SCN-based materialized view log cannot be created on table "string"."string" when there exist direct load/PMOP log entries for the table
Cause: An attempt was made to create a commit SCN-based materialized view log on a table which had direct load/PMOP log entries in sys.sumdelta$ and sys.sumpartlog$.
Action: Refresh the table's dependent materialized views before creating commit SCN-based materialized view log on the table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32422：提交基于SCN的物化视图日志不能在表“ string ” 上创建。“ string ”当存在表的直接加载/ PMOP日志条目时,
.原因：试图在sys.sumdelta $和sys.sumpartlog $中具有直接装入/ PMOP日志条目的表上创建基于提交SCN的物化视图日志。,
.操作：在创建基于SCN的物化视图之前，刷新表的依赖物化视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-32422: commit SCN-based materialized view log cannot be created on table "string"."string" when there exist direct load/PMOP log entries for the table

1 个回答

相似问题