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

RMAN-06043: TAG option not supported for archive log copies

1 Answers  


ORA-01628: max # extents (string) reached for rollback segment string

1 Answers  


ORA-13236: internal error in R-tree processing: [string]

1 Answers  


ORA-01166: file number string is larger than string (string)

1 Answers  


PCC-00065: Userid required, but not specified.

1 Answers  






ORA-19569: no device is allocated to this session

1 Answers  


PLS-00207: identifier 'string', applied to implicit cursor SQL, is not a legal cursor attribute

2 Answers  


ORA-29343: user string (mapped from user string) does not exist in the database

1 Answers  


ORA-29360: retry operation. Too much concurrent activity

1 Answers  


ORA-01757: Must specify an object number

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  


ORA-07245: sfccf: unable to lseek and write the last block.

1 Answers  


Categories