Oracle database error code ORA-01416 – two tables cannot be outer-joined to each other

Oracle Database Error Code ORA-1416 Description :
two tables cannot be outer-joined to each other
Error Cause:
Two tables in a join operation specified an outer join with respect to each other. If an outer join is specified on one of the tables in a join condition, it may not be specified on the other table.

How to Solve :
Remove the outer join specification (+) from one of the tables, then retry the operation.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»