QSM-02115: mv references a remote object and is refreshed ON COMMIT

QSM-02115: mv references a remote object and is refreshed ON COMMIT
Cause: The capability in question is not supported when the materialized view references a remote object and is refreshed ON COMMIT.
Action: Re-phrase the query to avoid the reference to the remote object or alter the materialized view to be refreshed ON DEMAND.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02115：mv引用远程对象，并刷新ON COMMIT,
.原因：当物化视图引用远程对象并刷新ON COMMIT时，不支持所讨论的功能。,
.操作：重新排序查询以避免对远程对象的引用，或者更改待更新的物化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-02115: mv references a remote object and is refreshed ON COMMIT

1 个回答

相似问题