Oracle DBA, How To, Error, Cause and Action

ORA-01799: a column may not be outer-joined to a subquery

ORA-01799: a column may not be outer-joined to a subquery




Cause: (+) () is not allowed.




Action: Either remove the (+) or make a view out of the subquery. In V6 and before, the (+) was just ignored in this case.