Hi Guys,
My application Team received the below error:-
ORA-01417: Tabelle darf mit max. einer anderen Tabelle durch Outer-Join verbunden werden
ORA-02063: vorherige line von PMT
01417. 00000 - "a table may be outer joined to at most one other table"
*Cause: a.b = b.b and a.c = c.c is not allowed
*Action: Check that this is really what you want, then join b and c first
in a view.
As a part of ORACLE DBA i have found that this is the restriction of OUTER JOINs in 12C//
https://www.salvis.com/blog/2015/12/07/outer-join-operator-restrictions-in-12-1-0-2/
But still i am not able to resolve it. Need help from developers ,Please assisst me with this code & if possible please refined it, so that it can work on 12C as well.
Application Team is fetching data from REMOTE database using DBLINK.
Please provide you valuable output for same.
Please provide you valuable output for same. Thanks in advance
With Best Regards