ORA-30336: no child for specified JOIN KEY



ORA-30336: no child for specified JOIN KEY..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00331: log version string incompatible with ORACLE version string

2 Answers  


KUP-04011: file system is full

1 Answers  


NNL-00299: Scheduled server cache dump to occur in string

1 Answers  


NNL-00553: Displays forwarding statistics

1 Answers  


PCC-01003: Invalid continuation at line number in file string

1 Answers  






ORA-09354: Windows 32-bit Two-Task driver: ORACLE task unexpectedly died

1 Answers  


RMAN-12009: command aborted because some backup pieces could not be located

1 Answers  


RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


DRG-11838: Proxy Reauthentication Required

1 Answers  


ORA-22055: unknown sign flag value [string]

1 Answers  


TNS-12645: Parameter does not exist.

1 Answers  


ORA-12561: TNS:unknown error

1 Answers  


Categories