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-13609: The specified task string must be executing to be cancelled or interrupted.

1 Answers  


PCC-02334: SQL identifier was not declared as a cursor

1 Answers  


ORA-16063: remote archival is enabled by another instance

1 Answers  


ORA-19736: can not plug a tablespace into a database using a different national character set

1 Answers  


ORA-06444: ssvpstev: Failed with unexpected error number.

1 Answers  






ORA-14456: cannot rebuild index on a temporary table

1 Answers  


DRG-11712: multiple Broader Terms for term string

1 Answers  


TNS-12155: TNS:received bad datatype in NSWMARKER packet

1 Answers  


SQL*Loader-00703: Internal error: argument number

1 Answers  


ORA-31047: Could not retrieve resource data at path string

1 Answers  


ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero

1 Answers  


ORA-29844: duplicate operator name specified

1 Answers  


Categories