标题: ORA-30398: illegal JOIN KEY clause [打印本页] 作者: admin 时间: 2016-9-4 20:10 标题: ORA-30398: illegal JOIN KEY clause ORA-30398: illegal JOIN KEY clause Cause: A JOIN KEY clause wasspecified 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 levelsatisfy
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 inthe
hierarchy. Action: Modify the JOIN KEYclause so that it satisfies the conditions mentioned
above.