ORA-30365: left relation in the JOIN KEY clause cannot be
same as right



ORA-30365: left relation in the JOIN KEY clause cannot be same as right..

Answer / guest

Cause: The relation of the child columns on the left side of
the JOIN KEY clause was the same as that of the parent level
on the right side.

Action: Remove the JOIN KEY clause. It is not required or
allowed when the child and the parent are in the same relation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32592: all columns in log group can not be no log columns

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


ORA-31409: one or more values for input parameters are incorrect

1 Answers  


ORA-23300: %s

1 Answers  


IMG-00813: boundary queue free failed

1 Answers  






RMAN-06110: changed controlfile copy unavailable

1 Answers  


PLS-00417: unable to resolve "string" as a column

1 Answers  


ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string

1 Answers  


QSM-01035: a row level security policy exists on this table

1 Answers  


ORA-00721: changes by release string cannot be used by release string

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  


ORA-31467: no column found in the source table

1 Answers  


Categories