ORA-30336: no child for specified JOIN KEY

ORA-30336: no child for specified JOIN KEY
Cause: The level specified in the REFERENCES portion of a JOIN KEY clause in a dimension DDL statement does not have a child level.
Action: Check the spelling of the level name referenced in the JOIN KEY clause. If the referenced level is the first level in the hierarchy, you need not and must not specify a JOIN KEY clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30336：没有指定JOIN KEY的子项,
.原因：维度DDL语句中的JOIN KEY子句的REFERENCES部分中指定的级别没有子级别。,
.操作：检查JOIN KEY子句中引用的级别名称的拼写。如果引用级别是层次结构中的第一级，则不需要，也不能指定JOIN KEY子句。,
.

aiaiDBA

13718043309

010-86462881

ORA-30336: no child for specified JOIN KEY

1 个回答

相似问题