ORA-30398: illegal JOIN KEY clause

ORA-30398: illegal JOIN KEY clause
Cause: A JOIN KEY clause was specified that did not conform to certain requirements. A JOIN KEY clause connecting a child level with its non-immediate ancestor level is allowed only when that child level and its ancestor level satisfy the following conditions:
1. The immediate parent of the child level must be a skip level.

2. The child level cannot be a skip level.

3. The ancestor level must be a non-skip level.

4. The ancestor level must be the nearest non-skip level to the child level in the hierarchy.

Action: Modify the JOIN KEY clause so that it satisfies the conditions mentioned above.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30398：非法JOIN KEY子句,
.原因：指定了不符合某些要求的JOIN KEY子句。仅当子级别及其祖先级别满足以下条件时，才允许将子级别与其非直接祖先级别连接的JOIN KEY子句：,
.1.子级别的直接父级必须是跳过级别。,
.,
.2.子级别不能是跳过级别。,
.,
.祖先级别必须是非跳过级别。,
.,
.4.祖先级别必须是层次结构中子级别的最近的非跳过级别。,
.,
.操作：修改JOIN KEY子句，使其满足上述条件。,
.

aiaiDBA

13718043309

010-86462881

ORA-30398: illegal JOIN KEY clause

1 个回答

相似问题