ORA-23543: materialized view log on "string"."string" is in an inconsistent state

ORA-23543: materialized view log on "string"."string" is in an inconsistent state
Cause: There was an error while creating the materialized view log and the log is currently in an inconsistent state. A possible cause could be that schema redefinition has occurred on the master table while the log was being created. Another possible cause could be that there were DMLs being applied on the master table concurrently in another session at the time the materialized view log creation started and those DML transactions haven't committed even after a very long period of time.
Action: Drop the materialized view log and recreate it.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-23543：物化视图登录“ string ”。“ string ”处于不一致状态,
.原因：创建物化视图日志时出错，并且日志当前处于不一致状态。可能的原因可能是在创建日志时在主表上发生了模式重定义。另一个可能的原因可能是，在物化视图日志创建开始时，在另一个会话中并发地在主表上应用DML，即使在很长一段时间后，这些DML事务仍未提交。,
.操作：删除物化视图日志并重新创建它。,
.

aiaiDBA

13718043309

010-86462881

ORA-23543: materialized view log on "string"."string" is in an inconsistent state

1 个回答

相似问题