ORA-12071: definition query of "string"."string" is invalid for offline instantiation

ORA-12071: definition query of "string"."string" is invalid for offline instantiation
Cause: Offline instantiation requires materialized view definition queries to observe the following constraints:
o The database link that will be used by the materialized view site to connect to the master site must be included with each master table referenced in the query.

o All master tables referenced must be located at the local site. References to other sites are not allowed.

Action: Modify the materialized view definition query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12071：“ string ”的定义查询。“ string ”对离线实例化无效,
.原因：离线实例化需要物化视图定义查询以遵守以下约束：,
.o将由物化视图站点用于连接到主站点的数据库链接必须包含在查询中引用的每个主表中。,
.,
.o引用的所有主表必须位于本地站点。不允许引用其他网站。,
.,
.操作：修改物化视图定义查询。,
.

aiaiDBA

13718043309

010-86462881

ORA-12071: definition query of "string"."string" is invalid for offline instantiation

1 个回答

相似问题