aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

XOQ-02529: The base attribute "string" of dimension "string" cannot be given an NVL expression because it is indexed.

XOQ-02529: The base attribute "string" of dimension "string" cannot be given an NVL expression because it is indexed.
Cause: An NVL expression was specified for a base attribute that is indexed. An attribute is indexed if it is explicitly marked as indexed by the user, or if it is a unique key attribute, or if the populate lineage flag is set.
Action: Remove the NVL expression or change the attribute so that it is not indexed, is not a unique key, and does not have the populate lineage flag set.

请先 登录 后评论

1 个回答

小智
XOQ-02529:维度“ string ”的基本属性“ string ”不能被赋予一个NVL表达式,因为它被索引。,
.原因:为索引的基本属性指定了一个NVL表达式。如果属性被明确标记为用户索引,或者是唯一的密钥属性,或者填充的谱系标志被设置,则将其编入索引。,
.操作:删除NVL表达式或更改属性,使其不被索引,不是唯一的键,并且没有设置填充的谱系标志。,
.
请先 登录 后评论