ORA-12016: materialized view does not include all primary key columns

ORA-12016: materialized view does not include all primary key columns
Cause: The query that instantiates the materialized view did not include all of the columns in the master's primary key constraint.
Action: Include all of the master's primary key columns in the materialized view query or create a ROWID materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12016：物化视图不包括所有主键列,
.原因：实例化实例化视图的查询不包括主节点主键约束中的所有列。,
.操作：在物化视图查询中包括所有主数据库的主键列，或创建一个ROWID物化视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-12016: materialized view does not include all primary key columns

1 个回答

相似问题