ORA-25954: missing primary key or unique constraint on dimension

ORA-25954: missing primary key or unique constraint on dimension
Cause: An attempt to create a join index was made, which failed because one or more dimensions did not have an appropriate constraint matching the join conditions.
Action: Ensure that the where clause is correct (contains all of the constraint columns) and that an enforced constraint is on each dimension table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:46

ORA-25954：缺少主键或维度上的唯一约束,
.原因：尝试创建连接索引，但由于一个或多个维没有与连接条件匹配的适当约束而失败。,
.操作：确保where子句是正确的（包含所有约束列），并且强制约束在每个维度表上。,
.

aiaiDBA

13718043309

010-86462881

ORA-25954: missing primary key or unique constraint on dimension

1 个回答

相似问题