Database Error Messages

ORA-38066

NSO regulate unnesting, semijoin elimination for IN and EXISTS subqueries with a view

Action

LEVEL ACTION --------------------------------------------------------------------------- 0 IN subquery with no correlation => unnest with transformation3 (nsojo3in()). EXISTS subquery or correlation => unnest with possible semijoin elimination (nsojo2()) 1 IN subquery with no correlation => unnest with transformation3 (nsojo3in()). EXISTS subquery or correlation => unnest (nsojo2()), disable semijoin elimination 2 disable semijoin elimination for a view, unnest with nsojo1() or nsojo2() 4 unnest with possible semijoin elimination (nsojo1(), nsojo2()) any other do not unnest with nsojo1() or nsojo2()