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

SQL*Loader-00279: Only APPEND mode allowed when parallel load specified.

1 Answers  


ORA-00309: log belongs to wrong database

1 Answers  


ORA-09761: pw_destroyPorts: server call pws_stop_instance failed.

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  


ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'

1 Answers  






ORA-03241: Invalid unit size

1 Answers  


RMAN-06147: no obsolete backups found

1 Answers  


ORA-38453: ExpFilter index should be created in the same schema as the base table.

1 Answers  


ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


QSM-01018: single table materialized join view rewrite not required

1 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  


ORA-02072: distributed database network protocol mismatch

1 Answers  


Categories